[Solved] Mysql Crash

[dl5ark1]

Hello,

 

could you please repair or restore the latest current version of the following databases:

 

user: dl5ark

server: stevie

 

databases:

dl5ark_blitzortung

dl5ark_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

[dl5ark1]

Hello Admins,

 

please can you help me?

[Byron]

This support request is being escalated to our root admin.

[Krydos]

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.

[dl5ark1]

[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: OK

Table './dl5ark_blitzortung/mybo_strikes' is marked as crashed and last (automatic?) repair failed

[Krydos]

You might need to restore that table from your latest backup then if the repair function won't fix it.

[dl5ark1]

Restoration Assistant: Restoring database "dl5ark_blitzortung"

But nothing happens.

phpMyAdmin: mybo_strikes: in use

What now?

[wolstech]

Did you drop the table first? If not, drop that table and try again.

[dl5ark1]

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?

[Krydos]

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.

[dl5ark1]

Upload to /home/dl5ark was done.

[Krydos]

Is it working now?

[dl5ark1]

Yes, thanks. What was the problem?

[Krydos]

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.

[dl5ark1]

o.k., nice.

But why i cannot restore it with the wizard?