Tag: innodb_file_per_table=OFF

How to Handle Wrong Page Type In External Pages

Mainly, the first step to successful MySQL data recovery is finding InnoDB pages with your data. Let’s call it the first step, because prerequisite steps are already done. An InnoDB page type is a two bytes integer in the header of a page. For MySQL data recovery two of them are important: FIL_PAGE_INDEX. Pages of […]

Read More

Recovery After DROP TABLE, With Innodb_file_per_table OFF

UPDATE (01/01/2017): We stopped further development of undrop-for-innodb and don’t support its open source versions anymore. 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 […]

Read More