How to Recover MySQL Table Structure from .frm File

Written by

Yujin Boby

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

Comments