Hi all,
Recently I started out on restoring ("apply-log") InnoDB tables, backed up via ibbackup utility. I have followed the documentation here:
http://www.innodb.com/support/documentation/innodb-hot-backup-manual
The restore works as described in the docs. However, starting mysql server (4.1.20), throws the following errors in the log file:
--------
InnoDB: Doing recovery: scanned up to log sequence number 2998 1937094156
071024 16:52:34 InnoDB: Error: table 'MyProdDB/tblProd'
InnoDB: in InnoDB data dictionary has tablespace id 13623,
InnoDB: but tablespace with that id or name does not exist. Have
InnoDB: you deleted or moved .ibd files?
InnoDB: This may also be a table created with CREATE TEMPORARY TABLE
InnoDB: whose .ibd and .frm files MySQL automatically removed, but the
InnoDB: table still exists in the InnoDB internal data dictionary.
InnoDB: Please refer to
InnoDB:
http://dev.mysql.com/doc/mysql/en/InnoDB_troubleshooting_datadict.html
InnoDB: for how to resolve the issue.
------
I have followed the trouble shooting doc, but it didn't solve the issue. Any help regarding this is very much appreciated. Thanks.
- Sandeep