Data sync not working

[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