Mysql报错:[ERROR] mysqld File ‘.mysql-bin.010228‘ not found (Errcode 2 “No such file or directory“)
作者:
tbpdba
Mysql报错:[ERROR] mysqld File ‘.mysql-bin.010228‘ not found (Errcode 2 “No such file or directory“)
背景:
迁移数据库,源数据库没有启用binlog,将源数据库关闭后整库拷贝到目标数据库并开启binlog
启动mysql报错,查看日志 tail -f -n 200 error.log
有报错:
2022-05-23 19:00:53 0 [ERROR] mysqld: File ‘./mysql-bin.010228’ not found (Errcode: 2 “No such file or directory”)
2022-05-23 19:00:53 0 [ERROR] Failed to open log (file ‘./mysql-bin.010228’, errno 2)
2022-05-23 19:00:53 0 [ERROR] Could not open log file
解决:
将原来发mysql-bin.index文件删除或者将mysql-bin.index移到/tmp目录下。
启动mysql即成功。
版权声明:本文为博主原创文章,未经博主允许不得转载。



