How to get rid of “Error 1062 Duplicate entry '1' for key 1”? August 30, 2014 05:27 "Insert sync" and "Update sync" options should be activated for all tables. At least, one unique primary key field per synchronizing table should be specified. Otherwise, the synchronization is not performed properly. Related articles Trigger-based database synchronization Autodetection of potential migration issues. Errors and Warnings What is Database synchronization? DBConvert, DBSync, Studio tools: what are the general differences? “ERROR 2013: Lost connection to MySQL server during query” appears. How to overcome it? Comments 0 comments Please sign in to leave a comment.