Mysql报错：[ERROR] mysqld File ‘.mysql-bin.010228‘ not found (Errcode 2 “No such file or directory“)https://www.cndba.cn/tbpdba/article/116547https://www.cndba.cn/tbpdba/article/116547

背景：
迁移数据库，源数据库没有启用binlog，将源数据库关闭后整库拷贝到目标数据库并开启binloghttps://www.cndba.cn/tbpdba/article/116547

启动mysql报错，查看日志 tail -f -n 200 error.loghttps://www.cndba.cn/tbpdba/article/116547

有报错：

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 filehttps://www.cndba.cn/tbpdba/article/116547

解决：
将原来发mysql-bin.index文件删除或者将mysql-bin.index移到/tmp目录下。

启动mysql即成功。https://www.cndba.cn/tbpdba/article/116547

版权声明：本文为博主原创文章，未经博主允许不得转载。