一、锁表
master> flush tables with read locak;
二、获取二进制日志当前 File 及 Position值
master>show master status\G;
三、备份当前数据库
$ mysqldump -all-databases -u root -proot1 >backup.sql
四、解锁Master 表
master>unlock tables;
五、Slave 上还原数据
$mysql -u root -proot1 <backup.sql
六、设置指向Master
slave>change master to
master_host='Master',
master_port=3306,
master_user='slave',
master_password='123456',
master_log_file='mysql-bin.000001',
master_log_pos=476;
七、启动slave
slave> start slave;