Mysql - Error 121203 reading the header from binary log, Error 121010 failed to open log

Error 121203 reading the header from binary log

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

121203 14:20:43 [ERROR] I/O error reading the header from the binary log, errno=-1, io cache code=0
121203 14:20:43 [ERROR] I/O error reading the header from the binary log
121203 14:20:43 [ERROR] Can't init tc log
121203 14:20:43 [ERROR] Aborting


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

Thats it, now your mysql will start with the new log file. Alos check with the two areas /var/run/*.pid and /var/lock/subsys/*. These are expected to agree with each other.

The topic on Mysql - Error 121203 reading the header from binary log is posted by - Math

Hope you have enjoyed, Mysql - Error 121203 reading the header from binary logThanks for your time