MySQL8 删除binlog.0000XXX文件导致无法启动

MySQL8无法启动,由于误删除的日志文件binlog.0000XXX。

找到MySQL8目录下的data.err文件中显示的错误信息为:

2022-12-19T11:22:23.973011Z 0 [System] [MY-010116] [Server] D:\phpstudy_pro\COM\..\Extensions\MySQL8.0.12\\bin\mysqld.exe (mysqld 8.0.12) starting as process 16216
mysqld: File '.\binlog.000054' not found (OS errno 2 - No such file or directory)
2022-12-19T11:22:24.649322Z 0 [ERROR] [MY-010811] [Server] Failed to open log (file '.\binlog.000054', errno 2)
2022-12-19T11:22:24.650369Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
2022-12-19T11:22:24.651003Z 0 [ERROR] [MY-010041] [Server] Can't init tc log
2022-12-19T11:22:24.651594Z 0 [ERROR] [MY-010119] [Server] Aborting

解决的方法可以参考下面的文章:

Linux MySQL 常见无法启动或启动异常的解决方案-学习收藏-20210411(https://blog.csdn.net/qq_38856012/article/details/115559874)

我选择了消除日志文件。在MySQL8中的data目录中找到binlog.index文件,清除其中的内容,MySQL8成功启动。

posted @ 2022-12-19 19:37  培轩  阅读(674)  评论(0)    收藏  举报