forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Synch problem on MySQL 4.0.17
- This topic is empty.
-
AuthorPosts
-
-
May 28, 2004 at 10:57 pm #8454frankbatrachMember
Just downloaded the latest SJA 2.0 to synch our master and slave databases. The synch process seemed to run OK (on a totally synched source/target pair) so as a quick test I tried changing a single record on the local DB. Unfortunately, although SJA runs without error the new record is not added to the target DB.
Environment:
Local: RedHat 8.0/MySQL 4.0.17-standard-log
Remote: SunOS 5.9/MySQL 4.0.17-log
My XML file is:
localhost -removed- -removed- 3306 dw mysql1.dca1.superb.net -removed- -removed- 3306 differentworld_com_1 favorite The structure of the favorite table is:
Column Information For – dw.favorite
Field Type Null Key Default Extra Privileges
IDTable tinyint(1) unsigned PRI 144 select,insert,update,references
IDRegion tinyint(1) unsigned PRI 0 select,insert,update,references
IDCountry smallint(2) unsigned PRI 0 select,insert,update,references
IDOwner int(4) unsigned PRI 0 select,insert,update,references
IDObject int(4) unsigned PRI (NULL) auto_increment select,insert,update,references
Parent varchar(24) binary YES MUL (NULL) select,insert,update,references
Property varchar(24) binary YES (NULL) select,insert,update,references
Index Information For – dw.favorite
Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment
favorite 0 PRIMARY 1 IDTable A (NULL) (NULL) (NULL) BTREE
favorite 0 PRIMARY 2 IDRegion A (NULL) (NULL) (NULL) BTREE
favorite 0 PRIMARY 3 IDCountry A (NULL) (NULL) (NULL) BTREE
favorite 0 PRIMARY 4 IDOwner A (NULL) (NULL) (NULL) BTREE
favorite 0 PRIMARY 5 IDObject A 5 (NULL) (NULL) BTREE
favorite 1 Parent 1 Parent A (NULL) (NULL) (NULL) YES BTREE
The output from the SJA job is:
SQLyog Job Agent Version 2.0
Copyright © Webyog. All Rights Reserved.
Sync started at Fri May 28 23:56:02 2004
Warning : Source and Target MySQL versions are not matching.
Source : 4.0.17-standard-log, Target : 4.0.17-log.
SJA may not work properly because of the difference in behaviour of concat_ws() across multiple MySQL versions.
Table SrcRows TgtRows Inserted Updated Deleted
========================= ======= ======= ======== ======= =======
favorite 5 4 0 0 No change
favorite 4 5 0 0 No change
Total time taken – 1 sec(s)
So although it sees that the source and target tables are different it doesn't actually update them. Anyone have any idea what I'm doing wrong?
-
May 29, 2004 at 3:04 am #15893RiteshMember
I believe you are using SJA for Linux. As I can see, you are doing a 2-way sync. SJA should work in this situation.
Can you send me a backup of the database so that I can run a sync at my place?
-
-
AuthorPosts
- You must be logged in to reply to this topic.