• Mysql crashes-I/O error reading the header from the binary log

    When trying to start mysql ,i got the following error :

    121010 13:57:47 [ERROR] I/O error reading the header from the binary log, errno=175, io cache code=0
    121010 13:57:47 [ERROR] I/O error reading the header from the binary log
    121010 13:57:47 [ERROR] Can’t init tc log
    121010 13:57:47 [ERROR] Aborting
     

    This means that you have a problem related to binary log files , 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

    🙂

    Categories: Mysql

    Comments are currently closed.