Table structures are stored in .frm files and in the InnoDB Data
Dictionary. Sometimes, usually in data recovery issues, we need to recover those
structures to be able to find the lost data or just to recreate
the tables.
There are different ways to do it and we’ve already written about
it in this blog. For example, we can use the data recovery tools
to recover table structures from InnoDB
Dictionary or from the .frm files using a MySQL Server. This blog
post will be an update of that last one. I will show you how to
easily recover the structure from a .frm file and in some cases
even …
[Read more]