mysql crashes…

So, what do you do when you get this from your logs?

I/O error reading the header from the binary log

Obviously the binary logs are broken, or at least the last one is. They are usually located in /var/logs/mysql/ and you should not start copying over some old logs with the new name because that would just not make it right, so the solution is,

  1. read your logs and see which *.bin file is corrupted
  2. delete it
  3. open /var/log/mysql/mysql-bin.index and delete the line with the bin file on it.
  4. Restart mysql

et voila 🙂

1 thought on “mysql crashes…

Leave a Reply

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

CommentLuv badge

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