MySQL Forums
Forum List  »  Data Recovery

Extract data from .ibd file
Posted by: Simon Quell
Date: March 18, 2021 07:11AM

Hi everyone,

we have a special Problem with a mysql database.
Due to a loss of data, we had to restore a database. It is an innoDB database. This worked quite well, unfortunately the associated .frm file for a specific table was missing. Only the .idb file is available. Is there a way to get to the data of the .idb file? We found an old .frm file during the restore, but it doesn't seem to fit. The table is displayed in phpMyAdmin, but the message always appears that the table does not exist.

I don't have much hope

But I would appreciate an opinion from the experts.

Options: ReplyQuote

Written By
Extract data from .ibd file
March 18, 2021 07:11AM
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.