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

Sync Runs, But Doesn't Move New Rows Over

forums forums SQLyog Sync tools, Migration, Scheduled Backup and Notifications Sync Runs, But Doesn't Move New Rows Over

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • #29174
      Jeanswhse
      Member

      Hi Kevin,

      If you don't mind, can you tell us the size of the database you try to sync?

      I try to do the same thing that sync to backup server. However, I have 2.5 million rows on a sales header file and 7.5 million rows on a sales detail file.

      I did sync the small size databases on daily basic. It was OK.

      Alfred

      SQLyog Enterprise V8.12

    • #29175
      Mahesh
      Member

      1) Are you sure that you are running sync over two different database and having difference in number of rows for table(s)?

      2) Can you please attach a job file here (you can remove password and server details if you want? )

    • #29176
      Kevinkidd
      Member

      Hi Sorry it has taken me so long to reply.

      Jeanswhse : most DB are one table to several tables and a few thousand rows.

      Mahesh: Yes, I'm syncing between two different databases. The back-up machine (192.168.1.41) and the live server (65.74.139.74). The live server get changed daily and I'm syncing it to the back-up. Anyway here is what I believe your asking for:

      65.74.139.74

      22

      3306

      1

      localhost

      3306

      0

      0

      cechelios08

      192.168.1.41

      22

      3306

      1

      localhost

      3306

      0

      0

      cechelios08

      Thanks for the help,

    • #29177
      navyashree.r
      Member

      Can you please attach Source and Target SQL dumps?

      And also with sample data which helps us to reproduce at our end?

      Regards,

      Navya

Viewing 3 reply threads
  • You must be logged in to reply to this topic.