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