If INNODB database doesn’t start

1) Put the following line in my.cnf

innodb_force_recovery=1

  • Restart MySQL

2) Dump the wrong table

3) Remove the line innodb_force_recovery=1 and restart MySQL

4) Drop the bad table and restore from backup

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.