mysql 主從數(shù)據(jù)不一致,提示： Slave_SQL_Running: No 的解決方法

mysql> show slave status\G;

mysql> stop slave;

mysql> set global sql_slave_skip_counter=1;

mysql> start slave;

mysql> show slave status\G;

mysql> flush table with read lock;

> mysqldump -uroot -p --opt -R 數(shù)據(jù)庫 > /data/bak.sql

mysql> show master status;

+------------------+----------+--------------+------------------+-------------------+
| File       | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+------------------+----------+--------------+------------------+-------------------+
| mysql-bin.000005 |   1158 |       |         |          |
+------------------+----------+--------------+------------------+-------------------+

mysql> stop slave;

mysql> source /data/bak.sql

mysql> reset slave;

mysql> CHANGE MASTER TO
MASTER_HOST='192.168.137.233',
MASTER_PORT=3306,
MASTER_USER='sync',
MASTER_PASSWORD='123456',
MASTER_LOG_FILE='mysql-bin.000005',
MASTER_LOG_POS=1158;

mysql> start slave;

mysql> show slave status\G;

mysql> unlock tables;