When a table gets dropped, MySQL removes the respective .frm file. This post explains how to recover the table structure if the table was dropped.
You need the table structure to recover a dropped table from the InnoDB tablespace. The B+tree structure of the InnoDB index doesn’t contain any information about field types. MySQL needs to know that in order to access records of the InnoDB table. Normally, MySQL gets the table structure from the .frm file. But when MySQL drops a table the respective frm file removed too.
Fortunately, there’s one more place where MySQL keeps the table structure. It’s the InnoDB dictionary.
The InnoDB dictionary is a set of tables where InnoDB keeps information about the tables. I reviewed them in detail in a separate InnoDB Dictionary post earlier. After the DROP, InnoDB deletes records related to the dropped table from …[Read more]