Recovering MySQL Database from EXT4 Formatted Hard Disk

Using PhotoRec to recover lost data
Forum rules
When asking for technical support:
- Search for posts on the same topic before posting a new question.
- Give clear, specific information in the title of your post.
- Include as many details as you can, MOST POSTS WILL GET ONLY ONE OR TWO ANSWERS.
- Post a follow up with a "Thank you" or "This worked!"
- When you learn something, use that knowledge to HELP ANOTHER USER LATER.
Before posting, please read https://www.cgsecurity.org/testdisk.pdf
Locked
Message
Author
ckoeber
Posts: 2
Joined: 29 Feb 2012, 23:28

Recovering MySQL Database from EXT4 Formatted Hard Disk

#1 Post 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.

User avatar
cgrenier
Site Admin
Posts: 5432
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 »

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

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: 5432
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 »

Ok, please let me know of the results.

Locked