Solution: MySQL Master-Master Replication Fails With ERROR 1200 (HY000) on Master

By Angsuman Chakraborty, Gaea News Network
Friday, November 16, 2007

When you try MySQL master-master replication with two (or more) servers you may often find that in the process of configuring the original master to also act as a slave server (start slave), it fails with the following error:

mysql> start slave;
ERROR 1200 (HY000): The server is not configured as slave; fix in config file or with CHANGE MASTER TO


To rectify it locate and delete the master.info file and restart the mysql server. Now try to start slave and it should work. In short on my machine I did:
rm /var/lib/mysql/master.info

Discussion

Tim
December 16, 2009: 4:57 am

Thanks for this post. You saved my day!!


Akom
February 10, 2009: 3:05 am

This saved me a lot of time, no doubt.

YOUR VIEW POINT
NAME : (REQUIRED)
MAIL : (REQUIRED)
will not be displayed
WEBSITE : (OPTIONAL)
YOUR
COMMENT :