-
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] AbortingThis 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,
- read your logs and see which *.bin file is corrupted
- delete it
- open /var/log/mysql/mysql-bin.index and delete the line with the bin file on it.
- Restart mysql
🙂
Open FTP Port 21 and 20 in Iptables firewall HyperVM Installation
Mysql crashes-I/O error reading the header from the binary log
Recent Posts
Categories
Archives
Comments are currently closed.