+1 (844) 533-0409

How to evaluate if MySQL table can be recovered

What are odds 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 that with 100% confidence there are ways to estimate recovery chances. I will describe few tricks. Generally speaking, if data is on media there […]

Continue Reading »

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

Continue Reading »

Presenting TwinDB Data Recovery Toolkit on #SFMySQL Meetup

On 5 November, I’ll be speaking at #SFMySQL Meetup about Data Recovery Software for MySQL 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 laptop with Linux. Download the latest […]

Continue Reading »

Recover Table Structure From InnoDB Dictionary

When a table gets dropped MySQL removes respective .frm file. This post explain how to recover table structure if the table was dropped. You need the table structure to recover a dropped table from InnoDB tablespace. The B+tree structure of InnoDB index doesn’t contain any information about field types. MySQL needs to know that in […]

Continue Reading »

Recover after DROP TABLE, innodb_file_per_table is ON

UPDATE (01/01/2017): We stopped further development of undrop-for-innodb and do not support its open source versions. Introduction In the previous post we described the situation when TwinDB recovery toolkit can be used to recover accidentaly dropped table in the case innodb_file_per_table=OFF setting. In this post we will show how to recover MySQL table or database […]

Continue Reading »
Loading...