MySQL Forums
Forum List  »  InnoDB

Re: InnoDB corruption, "table ... doesn't exist"
Posted by: Peter Brawley
Date: January 23, 2018 01:08PM

"Orphan" innodb tables are discussed at ...

https://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html
https://stackoverflow.com/questions/7759170/mysql-table-doesnt-exist-but-it-does-or-it-should
https://dba.stackexchange.com/questions/151076/innodb-table-does-not-exist

With an extended power outage, there may've been different sorts of damage to different tables, depending partly on what the server was trying to execute at the time. So absent rebuilding the damaged databases from scratch,you'll need to first collect specific read and write errors on each table, and try fixing them one at a time.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: InnoDB corruption, "table ... doesn't exist"
233
January 23, 2018 01:08PM


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.