MySQL Forums
Forum List  »  InnoDB

Recover data from .ibd file
Posted by: Marius F
Date: February 20, 2018 05:37AM

So i did a stupid thing. I deleted the ibdata1 file last night without even noticing. It was late at night, couldn't see good and so on..
I am trying now to recover the tables and the data. I did recover the tables from the .frm files but i am having trouble recovering the data from the .ibd ones.

I tried this in 2 ways:

1. Just copy the old .ibd file and overwrite the new ones. This will give an error that the tablespace id is different. I tried using a hex editor to change that value but i can't find it anywhere in the .ibd file

2. I used this tutorial here: https://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html
But everytime using this i get the error ERROR 1030 (HY000): Got error -1 from storage engine and the mysql server gets unstable until i delete the entire table/newdb
Any suggestions !?

Options: ReplyQuote


Subject
Views
Written By
Posted
Recover data from .ibd file
102
February 20, 2018 05:37AM


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.