mysql slave 错误解决

时间：2014-12-15 14:57:37 收藏：0 阅读：280

执行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复制了.

原文：http://www.cnblogs.com/hllnj2008/p/4164713.html