MySQL Forums
Forum List  »  Data Recovery

Re: data base recovery
Posted by: Aleksandr Kuzminsky
Date: November 11, 2020 12:16PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
131
November 11, 2020 03:45AM
Re: data base recovery
46
November 11, 2020 12:16PM
30
February 12, 2021 07:25AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.