mysql innoDB 挂了的临时解决方案

Mysql InnoDB: Error: checksum mismatch

by Mattias Hemmingsson on December 23, 2013 in Linux • 6 Comments

So efter I had publish mw post i got some mysql error.
The checksum did was not correct. So for solving this i had to.

 

Control the checksum ibdata is you innodb data file

innochecksum ibdata1 -d

So i have not all writen to database.
so lets write then with force

mysqld_safe  --innodb_force_recovery 4

Then when it done kill the mysql and restart it normaly and you data mysql should be up and running again.