slider

Tag: recovery after drop table

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

Presenting TwinDB Data Recovery Toolkit at the #SFMySQL Meetup

On 5 November, I’ll be speaking about Data Recovery Software for MySQL at the #SFMySQL Meetup. You might want to add Slipped & DROP’d your TABLE? Recover w/TwinDB’s Undrop for InnoDB toolkit to your calendar. There will be a demo, and if you want to try to undrop a table yourself bring in a Linux laptop. Further […]

Read More

Recovery After DROP TABLE, With Innodb_file_per_table ON

UPDATE (01/01/2017): We stopped further development of undrop-for-innodb and don’t support its open source versions anymore. Introduction In the previous post, we described a situation when the TwinDB recovery 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. So, […]

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