slave忽略复制错误

mysql> show variables like '%slave%';
+---------------------------+---------------+
| Variable_name | Value |
+---------------------------+---------------+
| init_slave | |
| log_slave_updates | OFF |
| slave_compressed_protocol | OFF |
| slave_exec_mode | STRICT |
| slave_load_tmpdir | /Disk/mysql/tmp |
| slave_net_timeout | 3600 |
| slave_skip_errors | OFF |
| slave_transaction_retries | 10 |
| sql_slave_skip_counter | |
+---------------------------+---------------+
9 rows in set (0.00 sec)

通常需要跳过一笔或n笔，使用
set global sql_slave_skip_counter=1; or
set global sql_slave_skip_counter=n;

start slave;

如想跳过所有错误修改配置文件
slave_skip_errors = ALL

restart mysql