{"id":1609,"date":"2015-12-22T11:49:00","date_gmt":"2015-12-22T03:49:00","guid":{"rendered":"https:\/\/cowmanchiang.me\/wp\/?p=1609"},"modified":"2023-10-31T15:43:10","modified_gmt":"2023-10-31T07:43:10","slug":"mysql-resolve-duplicate-entry-error-in-mysql-replication","status":"publish","type":"post","link":"https:\/\/cowmanchiang.me\/wp\/?p=1609","title":{"rendered":"[MySQL] Resolve duplicate entry error in MySQL Replication"},"content":{"rendered":"<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"\">while [ 1 ]; do if [ $(mysql -uroot -ppassword -e&quot;show slave status G;&quot; | grep &quot;Duplicate entry&quot; | wc -l) -eq 1 ] ; then mysql -uroot -ppassword -e&quot;stop slave; set global sql_slave_skip_counter=1; start slave;&quot;; fi; sleep 1; mysql -uroot -ppassword -e&quot;show slave statusG&quot;; done<\/pre>\n<p>Ref. <a href=\"https:\/\/codersofthedark.wordpress.com\/2014\/09\/17\/mysql-replication-duplicate-entry-for-primary-key\/\">MySQL Replication Error 1062: \u2018Duplicate entry for PRIMARY key\u2019<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>while [ 1 ]; do if [ $(mysql -uroot -ppassword -e&quot;show slave status G;&quot; | grep &quot;Duplicate entry&quot; | wc -l) -eq 1 ] ; then mysql -uroot -ppassword -e&quot;stop slave; set global sql_slave_skip_counter=1; start slave;&quot;; fi; sleep 1; mysql &hellip; <a href=\"https:\/\/cowmanchiang.me\/wp\/?p=1609\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[62],"tags":[],"class_list":["post-1609","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/cowmanchiang.me\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1609","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cowmanchiang.me\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cowmanchiang.me\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cowmanchiang.me\/wp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cowmanchiang.me\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1609"}],"version-history":[{"count":1,"href":"https:\/\/cowmanchiang.me\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1609\/revisions"}],"predecessor-version":[{"id":1884,"href":"https:\/\/cowmanchiang.me\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1609\/revisions\/1884"}],"wp:attachment":[{"href":"https:\/\/cowmanchiang.me\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1609"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cowmanchiang.me\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1609"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cowmanchiang.me\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1609"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}