Hello All, I have setup Replication on two Redhat linux box 7.3 and 9.0 with MySQL-4.0.13 Running..
On Master the my.cnf is ================== [client] port = 3306 socket = /var/lib/mysql/mysql.sock # The MySQL server [mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock server-id = 1 log-bin [mysqldump] quick max_allowed_packet = 16M On Slave it is ============= [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock [mysql.server] user=mysql basedir=/var/lib master-host=66.xxx.xxx.xx3 master-user=repl master-password=password server-id=2 replicate-do-db=database [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid When I start Slave on the slave box it says this: mysql> SLAVE START; ERROR 1200: The server is not configured as slave, fix in config file or with CHANGE MASTER TO So I Executed This: mysql> CHANGE MASTER TO MASTER_HOST='66.xxx.xxx.xx3', MASTER_USER='repl', MASTER_PASSWORD='password',MASTER_LOG_FILE='server-bin.004', MASTER_LOG_POS=4994; and START SLAVE but the same error occurs. I have the master.info and relay-info cat master.info ============ 4 test 3306 60 cat relay-log.info ============= ./server-relay-bin.001 4 0 Any Help will be Appreaciated. Thank You, Tina. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
