ONJava.com -- The Independent Source for Enterprise Java
oreilly.comSafari Books Online.Conferences.


AddThis Social Bookmark Button
  Live Backups of MySQL Using Replication
Subject:   The server is not configured as slave
Date:   2009-01-21 20:51:47
From:   Wes_Reneau
I realize this is an older thread but I used it to setup replication on Ubuntu 8.04.

I followed the directions and when I typed 'start slave', I got the following error:

The server is not configured as slave

Did some gooling to find http://blog.taragana.com/index.php/archive/solution-mysql-master-master-replication-fails-with-error-1200-hy000-on-master/ post.

You have to do this, or at least I did.

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