Updating source problem

[jdhr]

Hi,

I`m trying to sync two mysql tables with SJA, they have exactly the same structure, but when we change the source table (updating 1 column of some registries) and execute sja, it doesn`t update the target table. It doesn`t throw errors and doesn`t freeze.

What could be happennig? Please i`m very hurry with this.

[Shadow]

Lots of things could be happening, you should provide us more info, e. g. table structure, sample data, version of target and source servers and SQLyog, anything you can think of!

[jdhr]

Ok,

mysql version is 4.0.2.d in target an source. The target uses win2003 and source win98 so Source : 4.0.20a-nt and Target : 4.0.20a.

the xml file used is

Code:

localhost
root 3306 autonorpe

//the target ip //
root 3306 autonorpe

`dboticketusuario`

the table structure is as the file shows

[jdhr]

Sorry,

the target is 4.0.20a-nt and the source 4.0.2a. We installed the 4.0.20d in both but winmysqladmin shows 4.0.20a, is the server version correctly?

Thanks

[Shadow]

What if you tell the job to abort on error and then run it? Did you check sja's log?

[jdhr]

Hi Shadow,

Whe´ve done that and the only thing that generates in the sja.log is

Code:

Sync started at Tue Jul 13 11:00:00 2004
 Warning : Source and Target MySQL versions are not matching.
Source : 4.0.20a, Target : 4.0.20a-nt.
SJA may not work properly because of the difference in behaviour of concat_ws() across multiple MySQL versions.

What do u think?

[Ritesh]

Strange. Both the servers are same and it should not cause any problem.

What is the output of SJA? SJA outputs information about the number of row(s) updated, inserted and deleted during the sync process.

[jdhr]

Hi Ritesh, this is the complete output:

Code:

SQLyog Job Agent Version 2.0
Copyright   Webyog. All Rights Reserved.

Sync started at Tue Jul 13 12:20:00 2004

Warning : Source and Target MySQL versions are not matching.
Source : 4.0.20a, Target : 4.0.20a-nt.
SJA may not work properly because of the difference in behaviour of concat_ws()
across multiple MySQL versions.

Table                      SrcRows  TgtRows  Inserted  Updated  Deleted
=========================  =======  =======  ========  =======  =======
`dboaparcaderologin`            12       10         0        0  No change
`dboticket`                    152      150         4        0  No change
`dbotickettarifas`             208      216         1        1  No change
`dboticketusuario`             219      183

Look i have changed the xml file so it sync more tables, but is like a timeout happened and doesn`t sync dboticketusuario (it doesn`t even shows the taken time). If we sync only dboticketusuario, it does the same.

So, what can i do?

[Shadow]

Have you checked the status “dboticketusuario”? It may be corrupted…

I created two tables according to the supplied .sql file, put some test data into them and started syncing. It worked for me!

[jdhr]

Shadow,

I´ve already checked the table in both sides and it doesn`t seem to be corrupted. Can u tell me:

– What`s your mysql version? and

– Do u know if the sja.exe file that comes with SQLyog 3.71 trial has any restriction?

Thanks

[Shadow]

I tested the sync on v4.1.0 and no, the trial version of SQLyog does not have any restriction apart from the time limit. SJA does not have any restrictions either!

[Author]

Posts