How to Recover MySQL Table Structure from .frm File

To recover MySQL table structure from .frm file, you can use dbsake. You can find dbsake documentation at http://dbsake.readthedocs.org/en/latest/.

To install dbsake, run

curl -s http://get.dbsake.net > dbsake
chmod u+x dbsake
mv dbsake /usr/local/bin/

To find the structure of a table from the .frm file, run

dbsake frmdump /path/to/table_name.frm

Back to MySQL