标签：Binlog has bad magic number
Binlog has bad magic number

症状：

mysql数据库无法正常启动，日志如下：

111110 14:41:22  InnoDB: Starting shutdown...
111110 14:41:28  InnoDB: Shutdown completed; log sequence number 0 103559
111110 14:41:28 [Note] MySQL: Shutdown complete

111110 14:43:06 [Note] Plugin 'FEDERATED' is disabled.
111110 14:43:06  InnoDB: Started; log sequence number 0 103559
111110 14:43:06 [ERROR] Binlog has bad magic number;  It's not a binary log file that can be used by this version of MySQL
111110 14:43:06 [ERROR] Can't init tc log
111110 14:43:06 [ERROR] Aborting

111110 14:43:06  InnoDB: Starting shutdown...
111110 14:43:11  InnoDB: Shutdown completed; log sequence number 0 103559
111110 14:43:11 [Note] MySQL: Shutdown complete

解决办法：

删除最后一个mysql-bin.x，打开mysql-bin.index 文件，删除对应的mysql-bin.x条目，重启。（未经测试）

本日志由 flyinweb 于 2011-11-10 15:40:17 发表到 数据库技术 中，目前已经被浏览 599 次，评论 0 次；

作者添加了以下标签： Binlog has bad magic number；