1 mysql> flush tables with read lock; 2 Query OK, 0 rows affected (0.00 sec)
1 [root@master ~]# mysqldump -uroot -p -B mydb > master.sql
1 [root@Slave01 ~]# mysql -uroot -padmin < master.sql
1 mysql> unlock tables; 2 Query OK, 0 rows affected (0.00 sec)
原文:https://www.cnblogs.com/lonelyxmas/p/10329310.html