MySQL Forums
Forum List  »  Replication

Re: Upgrade from 5.0 to 5.1
Posted by: Murray Muspratt-Rouse
Date: February 12, 2009 08:01AM

Let me answer my own questions, since no reply has been posted.

1. On the master I added a user, granted that user replication rights to everything, and added 'server-id=1' and 'bin-log=mysql-bin' to my.ini. I also took a backup.
2. On the slave I issued 'stop slave', restored the backup and used 'Change master to' to redefine the link to the master. I then started the slave. I did not have to upgrade to 5.1 - all i needed to do was use the 5.0 manual to get the 'change master to' command correct. I did not need to change my.ini.


Options: ReplyQuote

Written By
February 11, 2009 03:20PM
Re: Upgrade from 5.0 to 5.1
February 12, 2009 08:01AM
February 13, 2009 11:52PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.