Recovering/Rebuilding MySQL .FRM, .MY* files from IBDATA1

Posted by Synetech on Server Fault See other posts from Server Fault or by Synetech
Published on 2012-09-15T23:15:23Z Indexed on 2012/09/16 3:40 UTC
Read the original article Hit count: 585

I recently had an incident in which several MySQL files were wiped out (mostly from WordPress, but also a few of MySQL’s own files). The IBDATA1 file is unaffected, but several .frm are gone as are a few .myi and .myd files.

So now I need to find out if there is a way to rebuild the missing files from IBDATA1. I tried Googling it, assuming that such an issue has come up before, and indeed there were numerous search results (including this question), but all of the ones I looked at were the opposite, about recovering from .frm and .my* files or somehow required these files.

Is there a way to rebuild these files? I know I have a relatively recent backup (a .SQL file) if there isn’t, but I’m hoping that these are the kind of files that are rebuilt if missing or outdated.

© Server Fault or respective owner

Related posts about mysql

Related posts about data-recovery