mysql主从不同步,手动同步时,出现的错误:
- mysql>stop slave;
- mysql>change master to master_host='192.168.1.80',
- >master_user='admin',
- >master_password='123456',
- >master_log_file='mysql-bin.000519',
- >master_log_pos=107;
- ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in the MySQL error log
根据网上前辈的们的解决方法有两种:一种是删除从服务器中继日志,二是reset slave。
1:查看错误日志
- [root@test mysql]# tail test.com.err
- 121229 11:34:01 [ERROR] Could not find target log during relay log initialization
- 121229 11:38:05 [ERROR] Failed to open the relay log './81-relay-bin.000047' (relay_log_pos 12247)
- 121229 11:38:05 [ERROR] Could not find target log during relay log initialization 121229 11:42:51 [ERROR] Failed to open the relay log './81-relay-bin.000047'
- (relay_log_pos 12247)
- 121229 11:42:51 [ERROR] Could not find target log during relay log initialization
- 121229 11:42:54 [ERROR] Failed to open the relay log './81-relay-bin.000047' (relay_log_pos 12247)
- 121229 11:42:54 [ERROR] Could not find target log during relay log initialization
- 121229 11:44:41 [Note] 'CHANGE MASTER TO executed'. Previous state master_host='192.168.1.80', master_port='3306', master_log_file='',
- master_log_pos='4'. New state master_host='192.168.1.80', master_port='3306', master_log_file='mysql-bin.000583', master_log_pos='6682'.
- 121229 11:44:52 [Note] Slave SQL thread initialized, starting replication in log'mysql-bin.000583' at position 6682, relay log './test-relay-bin.000001' position: 4
2:查看二进制日志信息
- [root@test mysql]# cat relay-log.info
- ./test-relay-bin.000002
- 253
- mysql-bin.000583
- 6682
3:查看master信息
- [root@test mysql]# cat master.info
- 18
- mysql-bin.000583
- 6682
- 192.168.1.80
- rep
- 11111
- 3306
- 60
- 0
第一种解决方法:
- [root@test mysql]#service mysqld stop
- [root@test mysql]#rm -rf master.info
- [root@test mysql]#rm -rf relay-log.info
- [root@test mysql]#service mysqld start
- mysql>change master to master_host='192.168.1.80',
- >master_user='admin',
- >master_password='123456',
- >master_log_file='mysql-bin.000519',
- >master_log_pos=107;
- mysql>start slave;
第二种解决方法:
- mysql> reset slave;
- mysql>change master to master_host='192.168.1.80',
- >master_user='admin',
- >master_password='123456',
- >master_log_file='mysql-bin.000519',
- >master_log_pos=107;
- mysql>start slave;
本文出自 “-=湖边竹=-” 博客,请务必保留此出处http://bronte.blog.51cto.com/2418552/1103803