MySQL错误码汇总

提示：记录平常遇到的MySQL错误码

1、错误码1008

Last_SQL_Errno: 1008
Last_SQL_Error: Error 'Can't drop database 'onenext'; database doesn't exist' on query. Default database: 'onenext'. Query: 'drop database onenext'

主从同步时由于数据库两边之前数据库中信息残留导致
处理方法：

mysql> stop slave;
Query OK, 0 rows affected (0.00 sec)
mysql> set global sql_slave_skip_counter = 1;#跳过这一次同步，可以跳过多次
Query OK, 0 rows affected (0.01 sec)
mysql> start slave;
Query OK, 0 rows affected (0.00 sec)

2、错误码1872

mysql> start slave;
ERROR 1872 (HY000): Slave failed to initialize relay log info structure from the repository

启动slave报错，需要重新reset slave 后再启动
处理方法：

mysql> reset slave;
Query OK, 0 rows affected (0.01 sec)
mysql> start slave;
Query OK, 0 rows affected (0.02 sec)