MySQL how to get data from .frm 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 your ibdata* files (or perhaps in a per-table file if you've got file_per_table turned on).

Related Topic