bugcy013
8/4/2014 - 11:59 AM

Mysql Master Slave Break

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;