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. 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

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

migrated from May 6 '12 at 18:04

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

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. – ESG 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

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

Your Answer


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