slider

Tag: recovery table structure

How to Recover Table Structure From FRM Files Online

Recently we announced MySQL Data Recovery Portal. Here, we automated some data recovery routines and published a matching web interface. At first, it was a tool to estimate recovery chances from corrupted InnoDB tablespaces. Now, it’s an even more exciting and useful feature – recovery table structure from FRM files online. There are several methods to recover […]

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