Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

3 Answers 3

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
add comment

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

Which are the mysql errors?

share|improve this answer
add comment

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
add comment

Your Answer

 
discard

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.