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.
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.