I have what I believe is a corrupted MySQL table. In the database I can see there is only a .frm
file, not a .mdi
or .mdy
for it. How can I recover data from this .frm
file?
I believe that I have to get data from the ibdata1
file?
MySQLsql
I have what I believe is a corrupted MySQL table. In the database I can see there is only a .frm
file, not a .mdi
or .mdy
for it. How can I recover data from this .frm
file?
I believe that I have to get data from the ibdata1
file?
Best Answer
There is no data in the
.frm
file; that file only contains the table definition. However, if you're not running a MyISAM table, it's expected that there will be no.MYD
or.MYD
files, because those are only used for MyISAM tables. Instead, the data will be somewhere else -- for InnoDB tables, for instance, it'll be in youribdata*
files (or perhaps in a per-table file if you've gotfile_per_table
turned on).