Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

The linux machine on which we have the mysql has crashed due to a power failure. This probably caused the mysql server to crash too and we are not now able to restore/backup/export the database from it using the standard command line commands. Are there any mysql tools which help in recovering this data ?

share|improve this question

Chances are good that you have got your tables and/or indexes damaged. Depending on what errors you get, you should use the CHECK TABLE and REPAIR TABLE statements. There is some more information on possible advanced recovery procedures in the MySQL documentation.

A backup is always good to have before doing stunts with important data - so don't forget to stop the mysql daemon and copy the entire /var/lib/mysql directory somewhere else before running any recovery commands.

share|improve this answer
+1 especially for the tip about making a backup first – Tom Shaw May 30 '11 at 10:03

Probably you should check the filesystem (fsck.ext3).

Which are the mysql errors?

share|improve this answer

After surfing the information on web about such tool, I found some good utility like Stellar Phoenix MySQL database recovery software. Although paid but claim to recover the database in every corruption scenario. The tool also repairs damaged MySQL tables created in Linux operating systems. Evaluate the software yourself by trying its demo version and check whether it worth the data need to recovered or not

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.