Mysql主从同步修复
flush tables with read lock;
mysqldump -uroot -ptestroot test > /mnt/mysql/mysql-backup/test.sql
scp /mnt/mysql/mysql-backup/test.sql root@192.168.1.101:/mnt/mysql/mysqlbackup/test.sql
show master status;
stop slave;
reset slave all;
mysql -uroot -ptestroot test < /mnt/mysql/mysql-backup/test.sql
change master to
master_host='192.168.1.101',master_port=9572,master_user='clone',
master_password='testroot',master_log_file='mysql-bin.000057',
master_log_pos=1366;
start slave;
unlock tables;
show slave status\G;