Recovery After DROP TABLE, With innodb_file_per_table ON

Author Andriy Lysyuk. Introduction In the previous post, we described a situation when the UnDrop For InnoDB toolkit can be used to recover an accidentally dropped table with innodb_file_per_table=OFF.In this post, we’ll show how to recover MySQL tables or databases if innodb_file_per_table is ON. This option tells InnoDB to store each table with a user… Continue reading Recovery After DROP TABLE, With innodb_file_per_table ON

Recovery After DROP TABLE, With innodb_file_per_table OFF

Author Andriy Lysyuk. Introduction Unfortunately, human mistakes are inevitable. That’s how life is. Wrong DROP DATABASE or DROP TABLE may destroy critical data on the MySQL server. Obviously, backups would help, however they’re not always available. This situation is frightening but not hopeless. In many cases it’s possible to recover almost all the data that… Continue reading Recovery After DROP TABLE, With innodb_file_per_table OFF

Recover Table Structure From InnoDB Dictionary

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… Continue reading Recover Table Structure From InnoDB Dictionary