[shaunie]

Hi,

I have noticed there was a space in the path and this has now been corrected, sorry!

However I am still not able to synchronise, here is an example of the output from the CMD window upon synchronisation:

SQLyog Job Agent Version 1.2

Copyright © Webyog. All Rights Reserved.

Sync started at Fri May 07 15:20:00 2004

Warning : Source and Target MySQL versions are not matching.

Source : 3.23.54, Target : 4.0.18-max-debug.

SJA may not work properly because of the difference in behaviour of concat_ws()

across multiple MySQL versions.

Table SrcRows TgtRows Inserted Updated Deleted

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

`Allocations` 100 100 0 80

It just hangs here for five minutes then gives up.

From reading earlier posts I gather that this might be because of conflicting mysql versions on the source and target. I originally installed 3.23.54 on the target to match the source version but because I am using windows 2000 on the target and unix as the OS on the source I had to upgrade to 4.0.18 on the target in order to alter the varibale 'lower_case_table_names' to 2 to avoid case sensitivity conflicts between the 2 operating systems. This feature was only introduced on 4.0.18 (http://dev.mysql.com/doc/mysql/en/Name_case_sensitivity.html)

As I am unable to upgrade the mysql version on the source, does this mean I can't do database backups?

Thanks for your help

[shaunie]

Hi,

Here is the path taken from the task manager window:

“C:Program FilesSQLyogsja.exe” C:Program FilesSQLyogWMS_Backup.xml

As you can see there are no spaces in the xml filename…

Have you got any other suggestions?

Thank you for your help 🙂

[Author]

Posts