执行CHANGE MASTER TO master_host............后报错
ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in the MySQL error log
查看日志
110830 15:43:01 [ERROR] Failed to open the relay log './localhost.000517' (relay_log_pos 75825983)
110830 15:43:01 [ERROR] Could not find target log during relay log initialization
解决办法
mysql> reset slave;
Query OK, 0 rows affected (0.00 sec)
原因:
该服务器之前做过主从复制,中途修改过my.cnf配置文件,重启mysql之后,binlog文件名和relay-log文件名已经改变,所以不能再从之前的relay-log复制了.
阅读(498) | 评论(0) | 转发(0) |