Re: data base recovery

[Aleksandr Kuzminsky]

Hi Thor,


.frm files store table schema, .ibd files store the data.
To recover the tables you need to recover the schema, then extract records from the .ibd files, and then load the records in some MySQL instance.

To recover the schema check out dbsake(https://dbsake.readthedocs.io/en/latest/commands/frmdump.html) or mysqlfrm (https://docs.oracle.com/cd/E17952_01/mysql-utilities-1.4-en/mysqlfrm.html). Personally, I used mysqlfrm more, but sometimes it's tricky. On other hand I heard good feedback about dbsake.

Now, when you have the tables schema in form of CREATE TABLE you can extract the records. For that you will need undrop-for-innodb(https://github.com/twindb/undrop-for-innodb). A stream_parser tool will parse your .ibd files. A c_parser tool will extract records from .pages (produced by stream_parser). Check out https://twindb.com/recover-corrupt-mysql-database/ for details.

Good luck.