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

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

启动mysql报错，查看日志 tail -f -n 200 error.log

有报错：https://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”)https://www.cndba.cn/tbpdba/article/116547https://www.cndba.cn/tbpdba/article/116547

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目录下。https://www.cndba.cn/tbpdba/article/116547

启动mysql即成功。

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