"System" <[EMAIL PROTECTED]> wrote: > 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 >
Replace all replication option from [mysql.server] section to the [mysqld] section of my.cnf. mysql.server can read only datadir, basedir and pid-file options. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
