slider

Tag: innodb_file_per_table=OFF

How to handle wrong page type in external pages

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

Read More

Recover after DROP TABLE, innodb_file_per_table is OFF

UPDATE (01/01/2017): We stopped further development of undrop-for-innodb and do not support its open source versions. Introduction Human mistakes are inevitable. Wrong “DROP DATABASE” or “DROP TABLE” may destroy critical data on the MySQL server. Backups would help however they’re not always available. This situation is frightening but not hopeless. In many cases it is […]

Read More