dl5ark1 Posted May 1, 2016 Share Posted May 1, 2016 Hello, could you please repair or restore the latest current version of the following databases: user: dl5arkserver: stevie databases:dl5ark_blitzortungdl5ark_smart-home I get this error messages: Table './dl5ark_blitzortung/mybo_strikes' is marked as crashed and last (automatic?) repair failed Incorrect key file for table './dl5ark_smart@002dhome/frewe_history.MYI'; try to repair it Link to comment Share on other sites More sharing options...
dl5ark1 Posted May 3, 2016 Author Share Posted May 3, 2016 Hello Admins, please can you help me? Link to comment Share on other sites More sharing options...
Byron Posted May 3, 2016 Share Posted May 3, 2016 This support request is being escalated to our root admin. Link to comment Share on other sites More sharing options...
Krydos Posted May 4, 2016 Share Posted May 4, 2016 Go to http://stevie.heliohost.org:2082/frontend/x3/sql/index.html and under the Modify Databases header select your database and click "Repair DB". Let us know if you need further assistance. Link to comment Share on other sites More sharing options...
dl5ark1 Posted May 4, 2016 Author Share Posted May 4, 2016 [dl5ark_blitzortung.mybo_cities] status: OK[dl5ark_blitzortung.mybo_conf] status: OK[dl5ark_blitzortung.mybo_densities] status: OK[dl5ark_blitzortung.mybo_raw] status: OK[dl5ark_blitzortung.mybo_stations] status: OK[dl5ark_blitzortung.mybo_stations_stat] status: OK[dl5ark_blitzortung.mybo_stations_strikes] status: OK[dl5ark_blitzortung.mybo_strikes] error: Can't create new tempfile: './dl5ark_blitzortung/mybo_strikes.TMD'[dl5ark_blitzortung.mybo_strikes] status: Operation failed[dl5ark_blitzortung.mybo_user] status: OKTable './dl5ark_blitzortung/mybo_strikes' is marked as crashed and last (automatic?) repair failed Link to comment Share on other sites More sharing options...
Krydos Posted May 4, 2016 Share Posted May 4, 2016 You might need to restore that table from your latest backup then if the repair function won't fix it. Link to comment Share on other sites More sharing options...
dl5ark1 Posted May 5, 2016 Author Share Posted May 5, 2016 Restoration Assistant: Restoring database "dl5ark_blitzortung"But nothing happens.phpMyAdmin: mybo_strikes: in useWhat now? Link to comment Share on other sites More sharing options...
wolstech Posted May 5, 2016 Share Posted May 5, 2016 Did you drop the table first? If not, drop that table and try again. Link to comment Share on other sites More sharing options...
dl5ark1 Posted May 6, 2016 Author Share Posted May 6, 2016 Drop was done. Table is no longer in use. Restoring database “dl5ark_blitzortung” with backup dl5ark_blitzortung.sql, but nothing happened. I use http://stevie.heliohost.org:2082/frontend/x3/backup/wizard-restore.html . Table 'dl5ark_blitzortung.mybo_strikes' doesn't exist and doesn't come back from restore. What's the problem? Link to comment Share on other sites More sharing options...
Krydos Posted May 6, 2016 Share Posted May 6, 2016 Ok, I've got two choices for you:Upload your latest dl5ark_blitzortung.sql file to /home/dl5ark/ and I'll manually edit it and import it for you.I can restore the table from an old 2014-07-22 backup that is still on the server.Let us know which option you would like to proceed with. Link to comment Share on other sites More sharing options...
dl5ark1 Posted May 7, 2016 Author Share Posted May 7, 2016 Upload to /home/dl5ark was done. Link to comment Share on other sites More sharing options...
Krydos Posted May 8, 2016 Share Posted May 8, 2016 Is it working now? Link to comment Share on other sites More sharing options...
dl5ark1 Posted May 8, 2016 Author Share Posted May 8, 2016 Yes, thanks. What was the problem? Link to comment Share on other sites More sharing options...
Krydos Posted May 8, 2016 Share Posted May 8, 2016 I edited your .sql file and removed everything except for creating the structure of mybo_strikes, and then adding the data to that table. Then I ran the command mysql dl5ark__blitzortung < dl5ark__blitzortung.mybo_strikes.sql You can look at the contents of the .sql file in your home directory, and the command I ran is just a command line import. Link to comment Share on other sites More sharing options...
dl5ark1 Posted May 9, 2016 Author Share Posted May 9, 2016 o.k., nice.But why i cannot restore it with the wizard? Link to comment Share on other sites More sharing options...
Recommended Posts