Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Sync Errors

forums › forums › SQLyog › Using SQLyog › Sync Errors

  • This topic is empty.
Viewing 0 reply threads
  • Author
    Posts
    • August 20, 2009 at 9:52 pm #11642
      Marakisoft
      Member

      I'm trying to sync three mysql databases located on three different mysql servers to a central mysql server located on a different location.

      the four databases are identical in structure each table has a composite key as a primary key (an auto-increment id, and station field). in all the database tables the auto-increment id starts from 1 and what differentiates similar tables in the database is the station field

      when i'm trying to sync the tables to the central server for the first time it completed successfully when i repeat the sync process a second time it displayed the following error “There was an error while execute a query. The query and the error has been logged in the log file.” when i open the log file i found the following:

      `customers` 463 2354 Error No. 1062

      Duplicate entry '232-7' for key 1

      463 0 0

      what should i do?

  • Author
    Posts
Viewing 0 reply threads
  • You must be logged in to reply to this topic.