MySQL Forums
Forum List  »  Data Recovery

Re: Extract data from .ibd file
Posted by: Aleksandr Kuzminsky
Date: March 18, 2021 11:12AM

To reads records from an .ibd file you need to know the record structure, the InnoDB index page or anything else in the .ibd file doesn't store anything about the table structure.

The are two sources of a table structure. The main is the .frm file that you lost. InnoDB keeps some information about the table structure for its own needs. Check if you see your table in information_schema.INNODB_SYS_TABLES and if you do, you can give a shot to sys_parser tool from Undrop-For-InnoDB toolkit.
Here I describe the process - https://twindb.com/recover-table-structure-from-innodb-dictionary-recover-table-structure-from-innodb-dictionary/
and a little demo starts at 14:26 in https://youtu.be/G9jBLkZqZRY?t=866

good luck!

Options: ReplyQuote


Subject
Views
Written By
Posted
7205
March 18, 2021 07:11AM
Re: Extract data from .ibd file
8842
March 18, 2021 11:12AM
2508
March 19, 2021 02:33AM


Sorry, you can't reply to this topic. It has been closed.

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.