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

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

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

?
1
2
3
4
5
6
7
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三条记录

?
1
2
3
4
5
6
7
8
9
10
11
[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 @   MR__Wang  阅读(136)  评论(0)  编辑  收藏  举报
相关博文：
·  MySQL slave upgrade: Slave failed to initialize relay log info structure from the repository
·  centos7 安装mysql 8.0.34 并配置主从
·  Failed to open log (file './mysql-bin.000232', errno 2)
·  MySQL 找不到binlog文件启动失败的解决办法
·  MySQL8 删除binlog.0000XXX文件导致无法启动
阅读排行：
· 25岁的心里话
· 闲置电脑爆改个人服务器（超详细） #公网映射 #Vmware虚拟网络编辑器
· 零经验选手，Compose 一天开发一款小游戏！
· 因为Apifox不支持离线，我果断选择了Apipost！
· 通过 API 将Deepseek响应流式内容输出到前端
历史上的今天：
2018-12-14 npm 更新版本
2018-12-14 XenServer中虚拟机和快照导出与导入
2018-12-14 nginx跨域的简单应用
点击右上角即可分享
微信分享提示
SQL AI 助手