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