Mysql Master Slave Break
Error :
Seconds_Behind_Master=NULL
Slave_SQL_Running=No
Last_Error=Error 'Duplicate entry '176932' for key 'PRIMARY'' on query. Default database
masterSide:
===================
mysql> show master status\G;
*************************** 1. row ***************************
File: bin.000004
Position: 808439164
Binlog_Do_DB:
Binlog_Ignore_DB:
1 row in set (0.00 sec)
ERROR:
No query specified
slave Side
===================
show slave status \G;
slave stop;
show slave status \G;
set master_log_pos=bin.000004, master_log_file=808401390 ;
set master_log_pos='bin.000004', master_log_file=808401390 ;
change master to master_log_pos='bin.000004', master_log_file=808401390 ;
change master to master_log_file='bin.000004', master_log_pos=808401390 ;
start slave;
show slave status \G;