系统断电后,MySQL重启失败:[ERROR] Binlog has bad magic number; It‘s not a binary log file that can be used by this version of MySQL

发布时间 2023-06-27 11:10:03作者: 黄豆芽

系统断电后,MySQL重启失败:

[ERROR] Binlog has bad magic number; It‘s not a binary log file that can be used by this version of MySQL

 [ERROR] Can't init tc log

[ERROR] Aborting

在Windows系统上,Mysql服务没启动,在启动Mysql服务时,报以下错误:

  系统出错。
    发生系统错误 1067。
    进程意外终止。

解决方案:

  删除 mysql-bin.index 文件。(请先备份,以免删除错误。),再重启Mysql服务即可。

 

以下是从网上找到的 其他人遇到的解决方案:

https://blog.csdn.net/CN_TangZheng/article/details/112177466

https://blog.csdn.net/xiaoborui20110806/article/details/36179259

https://blog.csdn.net/li_xiao_ming/article/details/49100147

https://www.yisu.com/zixun/34294.html

https://shipengliang.com/software-exp/binlog%E4%B8%AD%E6%9C%80%E5%AE%B9%E6%98%93%E8%B8%A9%E5%88%B0%E7%9A%84%E5%9D%91%E3%80%90%E8%BD%AC%E3%80%91.html

https://www.cnblogs.com/cfas/p/16733598.html