up vote 1 down vote favorite

This question already has an answer here:

I am developing a Java application with MySQL 5.6.13. A few days earlier I purchased a new laptop. I forgot to create a dump of application from previous laptop and instead I copied folder of my database(.ibd and .frm files) from datadir, when I installed MySQL 5.6.13 in new machine, and I had pasted my database(.ibd and .frm files) into datadir. The server is running fine. But in MYYOG IDE, when I open any of tables I am getting this error:

enter image description here

share|improve this question

marked as duplicate by Max Vernon, LowlyDBA, Marco, Julien Vavasseur, Colin 't Hart Jan 10 '17 at 10:40

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

up vote 3 down vote

*.ibd files are not enough, they store data, but InnoDB needs a dictionary which is stored in ibdata1.

To recover the tables you'll need a linux box. Then follow instructions in http://www.mysqlperformanceblog.com/2011/05/13/connecting-orphaned-ibd-files/

Or you can try method described by Chris Calender http://www.chriscalender.com/?p=28

In the worst case you'd need to fetch records from ibd files and then reload into fresh InnoDB instance. See instructions here http://www.percona.com/docs/wiki/innodb-data-recovery-tool:mysql-data-recovery:start

UPDATE: Data recovery toolkit moved to GitHub

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.