Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

We have a MySQL database that we have manage to grab the raw files from a server with a fatal hardware failure. However, this failure seems to have occurred when the DB server was running.

As a result we have the ibdata1 file, the ib_logfile0 and ib_logfile1 and all of the .frm files.

innodb_force_recovery does not work from 1 to 6.

Are there any tools on the market or methods that we can use to recover these databases?

Thanks in advance

PS - backups have also failed for a different reason

share|improve this question
add comment

migrated from stackoverflow.com May 6 '12 at 18:04

This question came from our site for professional and enthusiast programmers.

2 Answers

up vote 2 down vote accepted

You could try Percona's tools

share|improve this answer
    
From the documentation: It is important to understand that these tools are not designed for connecting to a live database and recovering data from it. They work on an offline copy of the data, and it is not safe to use them on a copy that is in use by MySQL. –  TheVedge May 4 '12 at 19:48
    
Thank you - I am trying these and also in touch with Percona directly. Any other suggestions, much appreciated! –  user1346416 May 4 '12 at 19:49
add comment

The long and the short of this is that percona's tools allow table by table recovery of your database.

What we managed to achieve was to get the server up and running again on the old HDD. Even though it went back into read only mode after a short period, that was enough for the db to repair enough of itself to be able to recover the data.

share|improve this answer
add comment

Your Answer

 
discard

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