Recovering MySQL Database from EXT4 Formatted Hard Disk

Using PhotoRec to recover lost data
Post Reply
Message
Author
ckoeber
Posts: 2
Joined: 29 Feb 2012, 23:28

Recovering MySQL Database from EXT4 Formatted Hard Disk

#1 Post by ckoeber » 29 Feb 2012, 23:35

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.

Sponsored links

User avatar
cgrenier
Site Admin
Posts: 3757
Joined: 18 Feb 2012, 15:08
Location: Le Perreux Sur Marne, France
Contact:

Re: Recovering MySQL Database from EXT4 Formatted Hard Disk

#2 Post by cgrenier » 29 Feb 2012, 23:44

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

ckoeber
Posts: 2
Joined: 29 Feb 2012, 23:28

Re: Recovering MySQL Database from EXT4 Formatted Hard Disk

#3 Post by ckoeber » 29 Feb 2012, 23:52

OK, thanks so much. I'll head to the MySQL forums and post back so you can add, if you choose.

User avatar
cgrenier
Site Admin
Posts: 3757
Joined: 18 Feb 2012, 15:08
Location: Le Perreux Sur Marne, France
Contact:

Re: Recovering MySQL Database from EXT4 Formatted Hard Disk

#4 Post by cgrenier » 01 Mar 2012, 23:41

Ok, please let me know of the results.

Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests