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
Category: MySQL Data Recovery
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
Recovering A Corrupt MySQL Database
Author Andriy Lysyuk. The unDROP for InnoDB tool can be used to recover corrupt MySQL databases. In this post, we will show how to repair a MySQL database if its files got corrupted and even innodb_force_recovery=6 doesn’t help. The corruption of InnoDB tablespace may be caused by many reasons. A dying hard drive can write… Continue reading Recovering A Corrupt MySQL Database
InnoDB Dictionary
Why Does InnoDB Need A Dictionary An InnoDB dictionary is a set of internal tables InnoDB uses to maintain various information about user tables. It serves as API between a human and the database. While the humans refer to tables by their names, InnoDB works with integer identifiers. The dictionary stores correspondence between table name… Continue reading InnoDB Dictionary