Sync Runs, But Doesn't Move New Rows Over

This topic is empty.

Viewing 3 reply threads

Author

Posts
- June 24, 2009 at 1:19 am #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
- June 24, 2009 at 6:36 am #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? )
- July 8, 2009 at 9:34 pm #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,
- July 9, 2009 at 7:35 am #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
Author

Posts