Monday, October 17, 2011

Error 'Duplicate entry '2619' for key 1' on query in MySQL

For resolving above error run below command on MySql Slave Server:
mysql> stop slave;
mysql> set GLOBAL SQL_SLAVE_SKIP_COUNTER=1;
mysql> start slave;

Then, check Slave status:
mysql> show slave status\G;
Now “Slave_IO_Running” and “Slave_SQL_Running” will be “Yes”.