Posted by: Administrator
on September 04, 2006 05:42 PM
Before this step: Once you've created the database, restart MySQL. Log back on to MySQL on the slave as root and update the master details (using the information you obtained by running show master status on the master:
CHANGE MASTER TO MASTER_HOST='hector', MASTER_USER='slave_user', MASTER_PASSWORD='password', MASTER_LOG_FILE='MySQL-bin.018', MASTER_LOG_POS=79;
I had to put this command in the slave: STOP SLAVE;
The problem is that I can't do this if the slave is running: Error: 1198 SQLSTATE: HY000 (ER_SLAVE_MUST_STOP)
Learn about Linux
Download Linux
Get Linux help
I had an error.
Posted by: Administrator on September 04, 2006 05:42 PMOnce you've created the database, restart MySQL. Log back on to MySQL on the slave as root and update the master details (using the information you obtained by running show master status on the master:
CHANGE MASTER TO MASTER_HOST='hector', MASTER_USER='slave_user',
MASTER_PASSWORD='password', MASTER_LOG_FILE='MySQL-bin.018', MASTER_LOG_POS=79;
I had to put this command in the slave: STOP SLAVE;
The problem is that I can't do this if the slave is running:
Error: 1198 SQLSTATE: HY000 (ER_SLAVE_MUST_STOP)
#