The typical error is as below:
The only trick you need to do is to reset the slave like this:Code:mysql> change master to master_host='abc.admon.org', master_user='replicator', master_password='PASSWORD', master_log_file='mysql-bin.000104', master_log_pos=106; ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in the MySQL error log mysql>
STOP SLAVE; RESET SLAVE;
Then, run your "change master xxx" again.


LinkBack URL
About LinkBacks




Reply With Quote