主库解决

锁表：

flush tables with read lock;

备份:

mysqldump -uroot -p'xxx'  idmesh > /root/mysql_bak_9_2.sql

查看master状态:

mysql -uroot -p'xxx' 
show master status;
master_log_file= 
master_log_pos =

拷贝到从库服务器：

scp /root/mysql_bak_9_2.sql root@xxx:/root/

从库解决

mysql -uroot -p'xxx' 
RESET REPLICA;
use idmesh;
source /root/mysql_bak_9_2.sql
change master to master_host='XXX',master_user='XXX',master_password='XXX',master_port=3306,master_log_file='XXX',master_log_pos=XXX;

重新开始主从同步

START REPLICA;

查看同步状态

show slave status\G;

主库解决：

解锁表

unlock tables;