Mysql InnoDB: Error: checksum mismatch

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.

 

And now you data should be in sync and you mysql run again.

  7 comments for “Mysql InnoDB: Error: checksum mismatch

  1. February 16, 2014 at 1:53 pm

    Thanks! You just save me 🙂

  2. February 27, 2014 at 5:34 am

    i have done this command earlier but i break the process, then it comes error again. am i have to wait until the process is finish? because it stop at ‘starting mysql daemon with database from xxx/xxx’ process .

  3. March 4, 2014 at 8:34 pm

    Hi

    Yes wait for the process is done.
    Then stop your mysql i think you may need to find the pid and kill it,
    Then restart mysql as usual and you should have you mysql back again.

  4. August 15, 2014 at 1:11 am

    140815 1:07:32 InnoDB: Error: data file /var/lib/mysql/ibdata_new/ibdata1 uses page size 32768,
    140815 1:07:32 InnoDB: but the only supported page size in this release is=16384

    this I have in log after mysqld_safe starts.
    could you please help me with it?

  5. August 15, 2014 at 8:43 am

    Hi

    What version of mysql are you using? It can be an bug that are in version 5.5.20 but fixed in version 5.5.22.
    In that case an update of mysql should fix the issue.

    // Mattias

    • sergio
      August 15, 2014 at 10:19 am

      5.6.4

  6. June 14, 2015 at 6:27 pm

    Thank you very much!

Leave a Reply

%d bloggers like this: