Recovering a MySQL database from a corrupted ext3 filesystem
Last week one of our servers decided to delete the entirety of /var, including all it's logs and our helpdesk's MySQL database. To make matters worse, although the backups live on a separate machine, they also appear to be missing /var and are thus useless.
I have tried a few different recovery utilities in an attempt to recover the database, the most successful being photorec [http://www.cgsecurity.org/wiki/PhotoRec], which has recovered 200+ frm (table definition) and MYI (MYISAM compressed data) files, but none of the MYD files which actually hold the data (it seems PhotoRec doesn't support recovering MYDs [http://www.cgsecurity.org/wiki/File_...ed_By_PhotoRec]).
Can anyone please point me to a tool/method for recovering MYD's from a corrupt ext3 filesystem. Assuming that's possible, a method of linking the MYD to it's appropriate frm and MYI (since the recovered files have random file names) would also be appreciated.
*Next task, review the backup verification procedure.
Lost Mysql dtabases as well
this has got to be one of the worst things to have happen,
catastrophic data loss!!!!
god i'm going to be skinned alive, if I can't come up with something.
photorec does only do .frm and .MYI but not the important .MYD.
is there anything i can do?