On Jan 12, 2010, at 12:36 PM, Lawrence Sorrillo wrote:
> I want to ensure that right after the reload that the same data is present in both
> the master and the slave. They are in perfect sync. Then I think its safe to consider
> starting binary logging and replication etc. And after these are started, changes can
> And in setting up replication in this manner I would not use the CHANGE MASTER... I
> will just
> in the my.cnf file and restart the slave server. From there it should start reading
> the binary logs and committing changes properly.
> Is this correct?
You're upgrading to MySQL 5.1, for which several of those options no longer have any
effect. Better to use CHANGE MASTER. See:
Sun Microsystems / MySQL Documentation Team
Madison, Wisconsin, USA