I've setup my my.cnf file on the slave as:
[mysql.server]
user=mysql
basedir=/var/lib
socket=/var/lib/mysql/mysql.sock
server-id=2
master-host=xxx.xxxxx.com
master-user=replicate
master-password=xxxxx
Show slave status indicates "NO" under Slave_running, and I get
mysql> slave start;
ERROR 1200: The server is not configured as slave, fix in config file or
with CHANGE MASTER TO
Server has been restarted.
Can anyone help correct this problem or know what is wrong?
Any help would be greatly appreciated. If you need more info please let me know.
Thanks
[mysql.server]
user=mysql
basedir=/var/lib
socket=/var/lib/mysql/mysql.sock
server-id=2
master-host=xxx.xxxxx.com
master-user=replicate
master-password=xxxxx
Show slave status indicates "NO" under Slave_running, and I get
mysql> slave start;
ERROR 1200: The server is not configured as slave, fix in config file or
with CHANGE MASTER TO
Server has been restarted.
Can anyone help correct this problem or know what is wrong?
Any help would be greatly appreciated. If you need more info please let me know.
Thanks