Mysql – Recover a MySQL InnoDB from ibdata1 that won’t repair using innodb_force_recovery

innodbMySQL

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

Best Answer