Data sync not working

[wwwild]

I cannot get the data syncronisation to work correctly. You can see this in the following dialog:

SQLyog Job Agent Version 4.0

Copyright © Webyog Softworks Pvt. Ltd.. All Rights Reserved.

Sync started at Mon Dec 06 12:15:32 2004

Table SrcRows TgtRows Inserted Updated Deleted

========================= ======= ======= ======== ======= =======

`account_dbs` 0 0 0 0 0

`account_details` 98 98 0 0 0

`account_pops` 0 0 0 0 0

`admin` 4 4 0 0 0

`affiliate_config` 7 7 0 0 0

`api_queue` 0 0 0 0 0

`audit_log` 6470 0 0 0 0

`authnet_batch` 0 0 0 0 0

`bandwidth_log` 0 0 0 0 0

the account_details, admin and affiliate_config tables are left untouched (as they should be) as they have the correct data in them. However, the audit_log table has no values inserted.

The other problem I have is that it is taking many hours to run!

I have tried this now between different MySQL hosts on different databases and have had similar problems. In one instance, the process deleted rows when nothing had actually changed!

Any ideas?

[wwwild]

Two more points I'll add to this post –

1. I am using a SSH tunnel for connections to both the source and target databases.

2. It appears to be a problem with tables with 100 or more rows of data. I notice this message in the error log when it happens on a table:

Error No. 2013

Lost connection to MySQL server during query

[Ritesh]

Are you specifying the same local port for both the servers ( for SSH tunneling )?

[wwwild]

Each connection is on a different port. Naturally, if they are on the same port, an error occurs.

[Ritesh]

Can you try the sync process without SSH tunneling?

Are both your source and target server located at remote machines? Is it possible to send some sample data with the table sturctures? It will be very helpful in reproducing the error out here. Also the XML schema that you are using will be helpful.

BTW, check out http://dev.mysql.com/doc/mysql/en/Gone_away.html. It might help you solving the error.

[wwwild]

Yes – both source and target servers are on remote machines.

Without SSH tunnelling it appears to work fine. So I guess that there is something going wrong with the SSH tunnel.

[Ritesh]

Can you cut-n-paste the XML schema for the job when you are using SSH tunneling (you can remove the username/password)?

Do you have MSN?

[wwwild]

Here is the schema:

user

password

machine name of source machine

22

3311

localhost

mysql user

mysql password 3306

mysql database name

user

password

machine name of target machine

22

3315

localhost

mysql user

mysql password 3306

mysql database name

[wwwild]

Trying it again, this time with correctly in code tags…

Code:

user
password
machine name of source machine
22
3311

localhost
mysql user mysql password 3306 mysql database name

user
password
machine name of target machine
22
3315

localhost
mysql user mysql password 3306 mysql database name

[Author]

Posts