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