slider

Tag: DROP DATABASE

How To Evaluate If MySQL Table Can Be Recovered

What Are the Odds a MySQL Table Can Be Recovered? This is the most asked question. Every single customer asks if their MySQL table can be recovered. Although it’s not possible to answer it with 100% confidence, there are ways to estimate recovery chances. I will describe a few tricks. Generally speaking, if data is […]

Read More

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

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 […]

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