MySQL Forums
Forum List  »  InnoDB

how to recover this innodb error ?
Posted by: Justin Xu
Date: February 16, 2013 08:03PM

The Mysql server 5.5.27 has been running more than 30 days, but the below error suddey occurs. the table files exists. how to repair or recover the problem? I restarted the Mysql server , but can't recover the error, the table can't be accessed.
Server version: 5.5.27-log MySQL Community Server (GPL)

-rw-rw---- 1 mysql mysql 8780 Dec 10 13:56 vol2012.frm
-rw-r----- 1 mysql mysql 98304 Dec 10 14:00 vol2012.ibd

130217 9:44:45 InnoDB: Error: table 'test/vol2012'
InnoDB: in InnoDB data dictionary has tablespace id 29165,
InnoDB: but a tablespace with that id does not exist. There is
InnoDB: a tablespace of name ./test/vol2012.ibd and id 28047, though. Have
InnoDB: you deleted or moved .ibd files?


Thanks
Justin

Options: ReplyQuote


Subject
Views
Written By
Posted
how to recover this innodb error ?
1517
February 16, 2013 08:03PM


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.