Rebuilding an existing slave from a master using cold-copying of /var/lib/mysql, would this be the proper process/order? Anything missing?
- master
mysql> SHOW MASTER STATUS\G
(take notes) - slave
mysql> STOP SLAVE;
- Shut down master and slave mysqld
- Move existing slave:/var/lib/mysql out of the way
- Copy master:/var/lib/mysql to slave:/var/lib/mysql
- Start master mysqld
- Start slave mysqld
- slave
mysql> CHANGE MASTER TO MASTER_HOST='masterserver',
-> MASTER_USER='replicationusername',
-> MASTER_PASSWORD='replcationpassword',
-> MASTER_LOG_FILE='logfilefromshowmasterstatus',
-> MASTER_LOG_POS=positionfromshowmasterstatus; - slave
mysql> start slave;