MySQL Forums
Forum List  »  InnoDB

Re: How to recover a table with a corrupted partition?
Posted by: harry sheng
Date: January 09, 2020 08:23AM

Before I posted my question in the fourm, I've tried innodb_force_recovery 1~3. When I have this parameter in my.cnf, I saw no error message in the mysql-error.log file, and I can connect mysql command-line client to it. But I could not fix the problem.

If I remove innodb_force_recovery from my.cnf, MySQL startup seemed to be fine, but I cannot connect mysql command-line client (on the same host as the MySQL server) to it.

It's in a lab environment, and I don't mind lossing data, so I tried innodb_force_recovery=6. This does not help with fixing the initial problem. After removing innodb_force_recovery from my.cnf and restart MySQL, I saw so much more errors in mysql-error.log file.

At this point, there's no going-back I guess.

Options: ReplyQuote

Written By
Re: How to recover a table with a corrupted partition?
January 09, 2020 08:23AM

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.