0

I am to attempting to recover data from a schema that had both MyISAM and InnoDB tables. I can recover the MyISAM tables without any problem, however I am running into difficulty trying to get the InnoDB tables back.

Steps taken:
I have backup of the schema folder in the data directory containing the .frm .myd and .myi files for the MyISAM tables and .frm for the InnoDB table. I also have the log files and the ibdata1 file. I managed to peek at the ibdata1 file with a hex editor and it clearly has references to my tables. I am starting the mysqld process with both -innodb_force_recovery=4 and -innodb_force_recovery=6 and recieve the following:

[ERROR] Cannot find or open table 'table' from the internal data dictionary of InnoDB though the .frm file for the table exists. Maybe you have deleted and recreated InnoDB data files but have forgotten to delete the corresponding .frm files of InnoDB tables, or you have moved .frm files to another database?
Or, the table contains indexes that this version of the engine doesn't support.
From what I have read I feel I have enough to make a proper recovery, however everything I have read so far has not helped.

Thank you in advance for any help.

3
Contributors
2
Replies
12
Views
1 Year
Discussion Span
Last Post by pascalwinkler
-1

To fix this do the following please or in case it isn’t enough for your mysql database restoration, then I would advise you to learn helpful threads dedicated to solving MySQL issues

http://community.office365.com/en-us/f/172/p/266451/815406.aspx
https://social.msdn.microsoft.com/Forums/en-US/fb94219c-fbf8-455d-b912-5544be11f186/how-to-fix-my-sql-database?forum=sqldataaccess
https://www.repairtoolbox.com/mysqlrepair.html Repair Toolbox for MySQL – in case you can’t get back mysql database, you may apply this one solution

Votes + Comments
The OP has been asking for 7 years. Go figure.
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.