Member Avatar for lennardrehder

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
  • 770 Views
  • 6 Days Discussion Span
  • Latest Post Latest Post by pascalwinkler
Member Avatar for pascalwinkler

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

commented: The OP has been asking for 7 years. Go figure. -1
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.