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 ?
Tell me more
×
Server Fault is a question and answer site for
professional system and network administrators. It's 100% free, no registration required.
|
|
|
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. |
|||
|
|
|
Probably you should check the filesystem (fsck.ext3). Which are the mysql errors? |
|||
|
|
|
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 |
|||
|
|
