MySQL Forums
Forum List  »  Data Recovery

InnoDB: recovery error
Posted by: Sandeep Chayapathi
Date: October 24, 2007 02:56PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
InnoDB: recovery error
5215
October 24, 2007 02:56PM
3250
October 25, 2007 12:30PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.