Re: How to recover a table with a corrupted partition?

[harry sheng]

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.