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.
Recovering MySQL Database from EXT4 Formatted Hard Disk
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
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
-
cgrenier
- Site Admin
- Posts: 5437
- Joined: 18 Feb 2012, 15:08
- Location: Le Perreux Sur Marne, France
- Contact:
Re: Recovering MySQL Database from EXT4 Formatted Hard Disk
.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
OK, thanks so much. I'll head to the MySQL forums and post back so you can add, if you choose.
-
cgrenier
- Site Admin
- Posts: 5437
- Joined: 18 Feb 2012, 15:08
- Location: Le Perreux Sur Marne, France
- Contact:
Re: Recovering MySQL Database from EXT4 Formatted Hard Disk
Ok, please let me know of the results.