Hi!
>>>>> "Paul" == Paul Chilson <[EMAIL PROTECTED]> writes: Paul> I am setting up a replication slave. Paul> Master is server-id = 1 Paul> Slave is server-id = 2 Paul> Relevant section of /etc/my.cnf from the slave <cut> Paul> My guess as to the problem: Paul> ./mysqladmin variables reports the slave as being server-id = 1 Paul> No matter what I can't change it. Paul> Permissions have been checked and double checked. Paul> Have been all around the globe on this one and can't figure it. Paul> Master is running MySql version 3.23.34 Paul> Slave is running MySql version 3.23.37 <cut> Paul> All indications are that the setup is correct but no updates happen. I am Paul> left to believe the server-id problem is causing this to not work. Paul> I understand that the server-id's need to be different on the master and the Paul> slave. Paul> On a test system at home when I change the server-id and restart the server Paul> the change takes. This test system is running MySql 3.23.43 Please upgrade your master from www.mysql.com; This is probably an incompatibility in the server protocol between the different versions. (We try to keep the protocol compatible but we have had to do a couple of small changes in the protocol to fix bugs in replication). Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland <___/ 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
