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

评论(0
© 2014 bubuko.com 版权所有 - 联系我们:wmxa8@hotmail.com
打开技术之扣,分享程序人生!