hi Victoria, The Master's server id is 1 while the slave's server id was set to 5. There is no problem for the slave to establish connection to the master. However, the slave complains that error reading packet from server, the reason is misconfigured-master, server id was not set and this messages keep on repeating. Any idea?
Thanks, Chee Peng ----- Original Message ----- From: "Victoria Reznichenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, September 27, 2002 9:16 PM Subject: Re: Re: Replication > Hello CP, > Friday, September 27, 2002, 3:11:14 AM, you wrote: > > C> hi Victoria, thanks for the reply. I have set server id in the very > C> beginning, but its still not working. I don't understand why the MySQL would > C> not let me change its server id accordingly. The server id was set to 1. > > You must set up unique server-id for the master and for the slave. You > said that server-id=1, but it's only one server id, what about > another? > > > -- > 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 > > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php