Mysql主从库不同步1236错误:could not find first log file name in binary....
来源:互联网 发布:js向div添加html 编辑:程序博客网 时间:2024/06/08 14:25
Mysql主从库不同步1236错误:could not find first log file name in binary log index file错误是主从的一个日志问题,我们只要简单的配置一下即可解决
最近造成Mysql主从库不同步问题,主要是因为电脑断了一下电,
从库日志中的错误:Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: ‘Could not find first log file name in binary log index file’
解决办法:
首先停止从库同步;
mysql >slave stop;
主库中关闭当前的二进制日志文件并创建一个新文件,新的二进制日志文件的名字在当前的二进制文件的编号上加1。
mysql >flush logs;
查看主库状态,主要查看日志文件和位置:
mysql >show master status;
回到从库中,执行命令,使日志文件和位置对应主库:
mysql >CHANGE MASTER TO MASTER_LOG_FILE='log-bin.000005',MASTER_LOG_POS=107;
最后,启动从库:
mysql >slave start;
show slave status;
状态如下,基本上是正常了,可以主库修改,测试一下从库是否同步。
Slave_IO_State: Waiting for master to send eventSlave_IO_Running: YesSlave_SQL_Running: Yes
阅读全文
0 0
- Mysql主从库不同步1236错误:could not find first log file name in binary....
- 'Could not find first log file name in binary log index file'的解决办法
- Could not find first log file name in binary log index file
- Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'Could not find
- Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'Could not find
- Mysql Administrator 弹出"Could not find settings"错误
- Could not find *.apk 错误
- Apache启动错误:No such file or directory httpd: could not open error log file......
- mysql 启动错误-server PID file could not be found
- mysql启动错误:server PID file could not be found!
- mysql 启动错误-server PID file could not be found
- mysql 启动错误-server PID file could not be found
- mysql 启动错误-server PID file could not be found
- mysql 启动错误-server PID file could not be found
- mysql主从库不同步的解决方法
- mysql主从库不同步问题解决方法
- 解决mysql主从不同步
- MySql主从不同步,解决方法
- Cookie,LocalStorage,SessionStorage的区别
- Java DNS cache 时效
- 详细解析 JavaScript 获取元素的坐标
- Python 3从入门到精通12-创建新文件并写入内容,在文件尾部更新内容
- OpenJudge[8469]特殊密码锁
- Mysql主从库不同步1236错误:could not find first log file name in binary....
- 开发中用到的比较好的转义工具
- pandas读取xml文件
- 理解 C++ 中继承层次的关键在于理解如何确定函数调用
- 菜单编写(VC_Win32)
- VIew的位置信息
- linux安装mysql之设置远程访问权限
- 简单了解Apache CXF
- spring aop理解