Sync Runs, But Doesn't Move New Rows Over

[Kevinkidd]

I have set the database synchronization to automatically run every night from 5 – 6 pm syncing certain databases on the source system, to ones on the target system. When I look at the target database in the morning it doesn't have any of the new items that were added to the source database the day before.

Here's the set up. On my PC at work, I have SQLyog 8.12. I'm connecting to our main Redhat server with mysql 4.1.22, which is outside if the building and back-up Redhat server with mysql 4.1.22, which is inside the building. All connections have been tested and work. Here's what my log file looks like for one of the databases: (Note the system doesn't run on Sat & Sun)

Sync started at Thu Jun 18 17:25:00 2009

`newest` 195 195 0 0 0

`newest_archive` 1656 1656 0 0 0

Sync started at Fri Jun 19 17:25:00 2009

`newest` 203 203 0 0 0

`newest_archive` 1656 1656 0 0 0

Sync started at Mon Jun 22 17:25:00 2009

`newest` 184 184 0 0 0

`newest_archive` 1682 1682 0 0 0

On Mondays this particular database pulls items from the newest table that over over 30 days old and moves them to the newest_archive table. Looking at the log file, it seems like it's working, but these two database (source & target) were very different, with the target always missing rows of data.

Please help,

Kevin

[Jeanswhse]

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

[Mahesh]

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? )

[Kevinkidd]

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,

[navyashree.r]

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