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 Why Additional extra views have been created in target database when converting from SQL database to MySQL? Trigger-based database synchronization Why have I received this “Error 1005: Can't create table... “? What is Database synchronization? Autodetection of potential migration issues. Errors and Warnings Comments 0 comments Please sign in to leave a comment.