Sign in with
Sign up | Sign in
Your question

Recover myisam database (MYD) after formatting drive from ext3 to ext4

Tags:
  • ext4
  • Database
  • Formatting
  • ext3
  • MySQL
Last response: in Linux/Free BSD
Share
October 3, 2014 9:05:38 AM

Hey,
I was upgrading my drive from ext3 to ext4 (complete single partition, ext3 to ext4), but accidentally formatted the wrong one, where my webserver and mysql databases were stored.
After having made an image of the drive using dd, just in case, I was able to recover most of the files using photorec which is part of testdisk. Unfortunately it wasn't able to recover the myd files, where the data is stored. I tried looking up the signature for these files and manually adding them to photorec without any luck, since I couldn't find the signature patterns.
Is there anything I could do to try to recover these files? All help will be greatly appreciated!

More about : recover myisam database myd formatting drive ext3 ext4

October 3, 2014 9:22:43 AM

Did you try the restore back to the same disk? If so , there may not be anything you can do. Try Recuva.
https://www.piriform.com/recuva
m
0
l
October 3, 2014 9:58:26 AM

The standard answer to this sort of question is that you forget trying to recover the files from the disk and restore from your backups.

You do keep backups, don't you, rather than playing Russian Roulette with your hard disk?
m
0
l
October 5, 2014 6:39:09 AM

@ss202sl No, I did the restore attempt to a separate drive. Isn't recuva only for windows and ntfs/fat based file systems? How does it differ from Photorec?
@Ijack If I could, I would've done that. I do keep backups, but somehow the backup disk was mounted at the same mount point as the main disk (I don't know how that happened), which means both the backups and the original data are gone.
m
0
l
!