# replace command in binary log not working

**URL:** <https://forums.percona.com/t/replace-command-in-binary-log-not-working/5998>\
**Category:** Percona Server for MySQL 5.6\
**Created:** [November 13, 2017, 1:21pm UTC](https://forums.percona.com/t/replace-command-in-binary-log-not-working/5998 "2017-11-13T13:21:25Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![chintoo02018](https://avatars.discourse-cdn.com/v4/letter/c/35a633/32.png) [@chintoo02018](https://forums.percona.com/u/chintoo02018)\
**Post date:** [November 13, 2017, 1:21pm UTC](https://forums.percona.com/t/replace-command-in-binary-log-not-working/5998/1 "2017-11-13T13:21:25Z")

</div>

I have binary log edit INSERT to REPLACE to overwrite the data in table but it showing Duplicate key error

```auto

[root&#64;etim upload_new]# mysql --defaults-extra-file=/usr/bin/.config145 < BHKR_mysql-bin.002873_13-11-17_2030_1.sql
ERROR 1062 (23000) at line 32: Duplicate entry '6354429' for key 'PRIMARY'

```

Binary log output as below

SET INSERT\_ID=6354429/_!_/;  
#171113 19:32:33 server id 10 end\_log\_pos 5363984 CRC32 0x349ae0c3 Query thread\_id=882 exec\_time=0 error\_code=0  
SET TIMESTAMP=1510581753/_!_/;  
replace into temp\_ticket(waybill\_no,etim\_no,trip\_no,route\_no,bus\_service,ticket\_code,ticket\_number,boarding\_stage,boarding\_stage\_code,from\_stage\_code,alright\_stage,alright\_stage\_code,till\_stage\_code,full\_ticket,half\_ticket,luggage\_qty,pass\_qty,total\_amt,ticket\_date,ticket\_date\_actual,ticket\_time, pass\_id,insp\_conc\_code,interstate\_code,full\_tkt\_amt,half\_tkt\_amt,lugg\_tkt\_amt,lastupdate,lastupdate\_id,status,bus\_capacity,ttl\_stages,seq\_no,is\_ex\_tkt,uid\_no,group\_ticket\_flag,secret\_code,maharashtra\_adult\_amount,maharashtra\_child\_amount,state\_1\_adult\_amount,state\_1\_child\_amount,state\_2\_adult\_amount,state\_2\_child\_amount,state\_3\_adult\_amount,state\_3\_child\_amount,state\_4\_adult\_amount,state\_4\_child\_amount,state\_5\_adult\_amount,state\_5\_child\_amount,actual\_adult\_fare\_from\_db,actual\_child\_fare\_from\_db,actual\_lugg\_fare\_from\_db,original\_maharashtra\_adult\_amount,original\_maharashtra\_child\_amount,original\_state\_1\_adult\_amount,original\_state\_1\_child\_amount,original\_state\_2\_adult\_amount,original\_state\_2\_child\_amount,original\_state\_3\_adult\_amount,original\_state\_3\_child\_amount,original\_state\_4\_adult\_amount,original\_state\_4\_child\_amount,original\_state\_5\_adult\_amount,original\_state\_5\_child\_amount,per\_adult\_original\_fare,per\_child\_original\_fare,per\_lugg\_original\_fare,reservation\_charge,gprs\_status,seat\_no,epurse\_ticket,refund\_ticket\_id,version\_type,divisionname,divisioncode,deponame,depocode,ASN\_amount,per\_adult\_service\_tax\_amount,per\_child\_service\_tax\_amount,service\_charge)values(‘109333’,‘BHKR5002’,‘000L1385’,‘61109’,‘3’,‘00’,‘023849’,‘001’,‘OO’,‘BHKR’,‘009’,‘O-’,‘NND’,‘02’,‘01’,‘00’,‘00’,‘0014300’,‘12/11/17’,‘2017-11-12’,‘17:12:42’,‘’,‘00’,‘0’,‘0011400’,‘0002900’,‘0’,‘’,‘’,‘’,‘44’,‘9’,‘’,‘0’,‘’,‘0’,‘0’,‘11400’,‘2900’,‘0’,‘0’,‘0’,‘0’,‘0’,‘0’,‘0’,‘0’,‘0’,‘0’,‘5670’,‘2850’,‘270’,‘11400’,‘2900’,‘0’,‘0’,‘0’,‘0’,‘0’,‘0’,‘0’,‘0’,‘0’,‘0’,‘5700’,‘2900’,‘300’,‘0’,‘1’,‘’,‘0’,‘0’,‘MOFF’,‘’,‘’,‘’,‘’,‘300’,‘0’,‘0’,‘0’),(‘109333’,‘BHKR5002’,‘000L1385’,‘61109’,‘3’,‘00’,‘023850’,‘001’,‘OO’,‘BHKR’,‘004’,‘O-’,‘SEBLAN’,‘01’,‘00’,‘00’,‘00’,‘0002200’,‘12/11/17’,‘2017-11-12’,‘17:13:05’,‘’,‘00’,‘0’,‘0002200’,‘0000000’,‘0’,‘’,‘’,‘’,‘44’,‘3.5’,‘’,‘0’,‘’,‘0’,‘0’,‘2200’,‘0’,‘0’,‘0’,‘0’,‘0’,‘0’,‘0’,‘0’,‘0’,‘0’,‘0’,‘2205’,‘1100’,‘120’,‘2200’,‘0’,‘0’,‘0’,‘0’,‘0’,‘0’,‘0’,‘0’,‘0’,‘0’,‘0’,‘2200’,‘0’,‘100’,’

====  
Create Table: CREATE TABLE `temp_ticket` (  
`ticket_id` int(11) NOT NULL AUTO\_INCREMENT,  
`waybill_no` int(100) NOT NULL,  
`etim_no` varchar(100) NOT NULL,  
`trip_no` varchar(10) NOT NULL,  
`route_no` int(100) NOT NULL,

`service_charge` int(20) NOT NULL,  
PRIMARY KEY (`ticket_id`),  
KEY `waybill_no` (`waybill_no`) USING BTREE  
) ENGINE=MyISAM AUTO\_INCREMENT=6595631 DEFAULT CHARSET=latin1  
1 row in set (0.00 sec)