Server_id is set but not relay_log and relay_index. On Tue, Aug 19, 2008 at 1:20 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote:
> is the server_id and relay_log and relay_index parameter set in my.cnf > > > On 8/19/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote: >> >> Hi, >> >> I am setting up replication and got the error below >> >> mysql> change master to master_host='172.20.1.189', master_user='repl', >> master_password='pass'; >> Query OK, 0 rows affected (0.01 sec) >> >> mysql> start slave; >> ERROR 1200 (HY000): The server is not configured as slave; fix in config >> file or with CHANGE MASTER TO >> mysql> exit >> Bye >> [EMAIL PROTECTED] ~]# tail /var/log/mysql/mysqld.log >> 080819 12:53:31 [Note] /usr/libexec/mysqld: Normal shutdown >> >> 080819 12:53:31 InnoDB: Starting shutdown... >> 080819 12:53:33 InnoDB: Shutdown completed; log sequence number 0 43665 >> 080819 12:53:33 [Note] /usr/libexec/mysqld: Shutdown complete >> >> 080819 12:53:34 InnoDB: Started; log sequence number 0 43665 >> 080819 12:53:34 [Note] /usr/libexec/mysqld: ready for connections. >> Version: '5.0.45-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 >> Source distribution >> 080819 12:55:41 [Warning] Neither --relay-log nor --relay-log-index were >> used; so replication may break when this MySQL server acts as a slave and >> has his hostname changed!! Please use >> '--relay-log=/var/run/mysqld/mysqld-relay-bin' to avoid this problem. >> >> >> -- >> Krishna Chandra Prajapati >> > > -- Krishna Chandra Prajapati
