Page 1 of 1

Recovering MySQL Database from EXT4 Formatted Hard Disk

Posted: 29 Feb 2012, 23:35
by ckoeber
Hello,

I am trying to recover MySQL databases (which were properly shut down) from an EXT4 formatted hard disk. I loaded the SystemRescueCD distro that has PhotoRec 6.12 on it.

With PhotoRec, I can recover parts of the MySQL Database but I cannot get the important *.IBD files (Files that have the InnoDB database data) on it because I guess PhotoRec doesn't have the signatures for that type of file. I loaded the extensions using the custom signature file feature and I believe I can get the "FRM" files (table structure files).

Anyone have experience recovering complete MySQL databases? I tried TestDisk but the partition itself isn't recoverable but PhotoRec can recover a lot of files that were on the disk.

Any thoughts? Thanks.

Thank you for your time.

Regards,

Chris K.

Re: Recovering MySQL Database from EXT4 Formatted Hard Disk

Posted: 29 Feb 2012, 23:44
by cgrenier
.frm files should already be recovered by PhotoRec but so far I have never find a way to identify InnoDB files. Maybe a Mysql developer may have a clever idea to identify the beginning of a file.

Re: Recovering MySQL Database from EXT4 Formatted Hard Disk

Posted: 29 Feb 2012, 23:52
by ckoeber
OK, thanks so much. I'll head to the MySQL forums and post back so you can add, if you choose.

Re: Recovering MySQL Database from EXT4 Formatted Hard Disk

Posted: 01 Mar 2012, 23:41
by cgrenier
Ok, please let me know of the results.