mysql主从故障跳过错误
1.从库报错 21,22,23,25无法执行
Retrieved_Gtid_Set: 265c6c2a-86ca-11ed-b07a-0242ac120002:1-25
Executed_Gtid_Set: 265c6c2a-86ca-11ed-b07a-0242ac120002:1-19,
2.navicat
工具-数据传输
修复主从的具体表
stop slave;
start slave;
show slave status\G;
不需要执行第三步
3.跳过错误
stop slave sql_thread;
set gtid_next='265c6c2a-86ca-11ed-b07a-0242ac120002:25'; (21,22,23,24,25都要执行)
begin;commit;
set gtid_next=automatic;
start slave sql_thread;
show slave status\G;