上一篇  |  下一篇
数据库技术
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 16:19:27 编辑

本日志由 flyinweb 于 2011-11-10 15:40:17 发表，目前已经被浏览 597 次，评论 0 次；

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

引用通告：http://www.517sou.net/Article/716/Trackback.ashx

评论订阅：http://www.517sou.net/Article/716/Feeds.ashx

评论列表

    暂时没有评论
(必填)
(必填，不会被公开)