重启mysql的时候,mysql日志也会抛错错误

修改mysql 配置文件,移动mysql数据存储位置修改。

重启mysql的时候,mysql日志也会抛错错误

2021-11-27T00:34:43.403963Z 0 [ERROR] Failed to open log (file '/logs/mysql-bin.000001', errno 2)
2021-11-27T00:34:43.403982Z 0 [ERROR] Could not open log file
mysqld: File '/logs/mysql-bin.000002' not found (Errcode: 2 - No such file or directory)
2021-11-27T00:34:43.404675Z 0 [ERROR] Failed to open log (file '/logs/mysql-bin.000002', errno 2)
2021-11-27T00:34:43.404866Z 0 [ERROR] Could not open log file
mysqld: File '/logs/mysql-bin.000003' not found (Errcode: 2 - No such file or directory)
2021-11-27T00:34:43.405652Z 0 [ERROR] Failed to open log (file '/logs/mysql-bin.000003', errno 2)

  

打开mysql-bin.index,删除mysql-bin.000001、mysql-bin.000002、mysql-bin.000003三条记录

[root@mysql57 logs]# cat mysql-bin.index 
/logs/mysql-bin.000004
/logs/mysql-bin.000005
/logs/mysql-bin.000006
/logs/mysql-bin.000007
/logs/mysql-bin.000008
/logs/mysql-bin.000009
/logs/mysql-bin.000010
/logs/mysql-bin.000011
/logs/mysql-bin.000012
/logs/mysql-bin.000013

  

重启mysql,则显示正常

 

posted @ 2022-12-14 10:42  MR__Wang  阅读(72)  评论(0编辑  收藏  举报