2013年5月5日星期日
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条目,重启。(未经测试)
订阅:
博文评论 (Atom)
没有评论:
发表评论