89511

start.

6.    Configure the slave with the replication coordinates from the master. This tells the slave the binary

log file and position within the file where replication needs to start. Also, configure the slave with the

login credentials and host name of the master. For morę information on the CHANGE MASTER TO

statement required, see Section 16.1.1.10, "Setting the Master Configuration on the Slave".

7.    Start the slave threads:

mysql>START SLAVE;

After you have performed this procedurę, the slave should connect to the master and catch up on any

updates that have occurred sińce the snapshot was taken.

If you have forgotten to set the server-id [1991] option for the master, slaves cannot connect to it.

If you have forgotten to set the server-id [1991] option for the slave, you get the following error in the slave's error log:

Warning: You should set server-id to a non-0 value if master_host is set; we will force server id to 2, but this MySQL server will not act as a slave.