InnoDB recovery after shutdown unexpectly

check innodb log file size:

-rw-rw—- 1 mysql mysql 100000 Oct20 17:50 ib_logfile0
-rw-rw—- 1 mysql mysql 100000 Oct 20 17:01 ib_logfile1

size is 10000
vi /etc/my.cnf

innodb_force_recovery=6
innodb_log_file_size=100000

service mysql restart
mysqldump -A all_db > all_db.sql

exit recovery mode by removing those two line that has been added
service mysql restart

drop the tables from the databases from backup

Leave a Reply

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