u need to set those parameters
On 8/19/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote: > > 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 > > >
