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: