Last_Errno: 1008 Last_Error: Error 'Can't drop database 'test1'; database doesn't exist' on query. Default database: 'test1'. Query: 'drop database test1'

問題：

mysql> show slave status\G

Slave_IO_Running: Yes
Slave_SQL_Running: No

Last_Errno: 1008
Last_Error: Error 'Can't drop database 'test1'; database doesn't exist' on query. Default database: 'test1'. Query: 'drop database test1'           

解決辦法：

mysql> slave stop;
#将binglog指針下移一個位置
mysql> set GLOBAL SQL_SLAVE_SKIP_COUNTER=1;

mysql> slave start;           

驗證：

mysql> show slave status\G
Slave_IO_Running: Yes
Slave_SQL_Running: Yes

Last_IO_Errno: 0
Last_IO_Error: 
Last_SQL_Errno: 0
Last_SQL_Error: