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成功启动。

浙公网安备 33010602011771号