MySQL 出现 Could not initialize master info structure 修复
MySQL 设定同步 Replication, 将下述命令拆成两组输入, 如下述:
1.mysql> CHANGE MASTER TO MASTER_HOST='master.example.com', MASTER_USER='repl', MASTER_PASSWORD='repl_password';
2.mysql> CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS=107;
设定 Replication 完成后, start slave 无法?⒍? 出现下述错误讯息:
Could not initialize master info structure, more error messages can be found in the MySQL error log
要怎么解决呢?
MySQL Replication 出现 Could not initialize master info structure 修复
MySQL error log 看不出有什么错误讯息, 可看此篇的讨论: MySQL :: Could not initialize master info structure, more error messages can be found in the MySQL error log
下述直接写解法:
| 代码如下 | 复制代码 |
| 1.mysql> reset slave; # 重点就是这行 2.mysql> CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS=107; # 请依照自行环境设定 3.mysql> start slave; # 就正常了. | |
4.?: 重新设置 slave, MASTER_LOG_FILE 和 MASTER_LOG_POS 会被清空, 所以需要重新设置.
您可能感兴趣的文章：
MySQL 出现 Could not initialize master info structure 修复
解决mysql报错ERROR 1201 (HY000):Could not initialize master info structure
MYSQL: Failed to open the relay log解决办法
mysql5.5提示Could not initialize master info structure
ERROR 1201 (HY000): Could not initialize master解决方法
MySQL主从配置提示Failed to initialize the master info structure错误
mysql同步中断报错 [ERROR] Slave: Query caused different errors
mysql5.1.34主从复制教程
MYSQL双机热备份的配置实施(问题总结)
MySQL Replication 遇到 Got fatal error 1236 from master 修复