synchronizing tables

This topic is empty.

Viewing 14 reply threads

Author

Posts
- October 28, 2003 at 5:04 pm #8220
  
  woki
  Member
  
  I'm just testing the Synchronizing feature. I started with an empty local database as target and on the other side a database hosted with an ISP.
  
  First synchronizing was ok – all tables are at the local database. When I tried out another synchronization process without any changes at the xml-file and the databases -> there a lots of errors like 'Duplicate entry '64' for key 1,Error No. 1062 ….
  
  key 1 is an unique key for the ID – field which hat autoincrement !
  
  Could you please help me
- October 29, 2003 at 1:54 pm #15147
  
  Ritesh
  Member
  
  Can you send me the structure of the table with sample data so that we can work on it and fix any bugs if there are any?
  
  You can mail them to [email protected]
- November 17, 2003 at 11:45 pm #15148
  
  qstoodley
  Member
  
  I too have experienced this problem. I have sent the structure to the above email address also.
  
  Thanks,
  
  Quentin.
- November 18, 2003 at 9:04 am #15149
  
  Ritesh
  Member
  
  I have received it.
  
  Will revert back soon.
- November 18, 2003 at 12:01 pm #15150
  
  Ritesh
  Member
  
  I made some changes in tables “tblweborders” and “tblwebquoteitems” for the target database and ran the sync tool. This is the output given by SJA.
  
  Code:
  
  SQLyog Job Agent Version 1.1
  Copyright (c) Webyog. All Rights Reserved.
  
  Sync started at Tue Nov 18 17:25:06 2003
  
  Table SrcRows TgtRows Inserted Updated Deleted
  ========================= ======= ======= ======== ======= =======
  `tblemaillist` 705 705 0 0 0
  `tblorderstatus` 13 13 0 0 0
  `tblorderstatushistory` 110 110 0 0 0
  `tblsurvey` 58 58 0 0 0
  `tblweborderitems` 94 94 0 0 0
  `tblweborders` 43 43 0 10 0
  `tblwebquoteitems` 25207 25207 0 13 0
  `tblwebquotes` 1801 1801 0 0 0
  `tblwebupgradeitems` 0 0 0 0 0
  
  Total time taken – 4 sec(s)
  
  Can you send me the SQL script of the target database with some modified data?
- November 18, 2003 at 12:13 pm #15151
  
  Ritesh
  Member
  
  BTW, which version of SQLyog are you running and the MySQL versions of your source and target server?
- November 18, 2003 at 10:41 pm #15152
  
  light_rock
  Member
  
  I am encountering a lot of very similar issues.
  
  It is 'happiest' if I start with a completely blank target
  
  database.
- November 19, 2003 at 1:20 am #15153
  
  Ritesh
  Member
  
  A similar problem existed in ver 3.6 and 3.61 but has been resolved in 3.62. Are you sure that you are running 3.62?
- November 19, 2003 at 3:33 am #15154
  
  qstoodley
  Member
  
  Thanks for looking into that.
  
  Does it still process ok if there are no changes made? I was getting the error after populating the target from scratch and then ran it again (before any changes would have been made) and got the error so I didn't bother trying it after changes had been made.
  
  I am running SQLYOG 3.62.
  
  I am also running MySQL 4.0.15-nt on both servers. Target is Windows 2000 Server and Source is Windows 2003 Server.
  
  Quent.
- November 19, 2003 at 9:22 am #15155
  
  Ritesh
  Member
  
  I ran the sync two times in enviroment(s) similar to yours. The first time ( when there are no tables in the target database ), I am getting the following result.
  
  Code:
  
  SQLyog Job Agent Version 1.1
  Copyright (c) Webyog. All Rights Reserved.
  
  Sync started at Wed Nov 19 14:44:01 2003
  
  Table SrcRows TgtRows Inserted Updated Deleted
  ========================= ======= ======= ======== ======= =======
  `tblemaillist` 705 0 705 0 0
  `tblorderstatus` 13 0 13 0 0
  `tblorderstatushistory` 110 0 110 0 0
  `tblsurvey` 58 0 58 0 0
  `tblweborderitems` 94 0 94 0 0
  `tblweborders` 43 0 43 0 0
  `tblwebquoteitems` 25207 0 25207 0 0
  `tblwebquotes` 1801 0 1801 0 0
  `tblwebupgradeitems` 0 0 0 0 0
  
  Total time taken – 5 sec(s)
  
  In the second test ( when there are tables in the target database but no changes have been done ), I get the following result.
  
  Code:
  
  SQLyog Job Agent Version 1.1
  Copyright (c) Webyog. All Rights Reserved.
  
  Sync started at Wed Nov 19 14:50:05 2003
  
  Table SrcRows TgtRows Inserted Updated Deleted
  ========================= ======= ======= ======== ======= =======
  `tblemaillist` 705 705 0 0 0
  `tblorderstatus` 13 13 0 0 0
  `tblorderstatushistory` 110 110 0 0 0
  `tblsurvey` 58 58 0 0 0
  `tblweborderitems` 94 94 0 0 0
  `tblweborders` 43 43 0 0 0
  `tblwebquoteitems` 25207 25207 0 0 0
  `tblwebquotes` 1801 1801 0 0 0
  `tblwebupgradeitems` 0 0 0 0 0
  
  Total time taken – 4 sec(s)
  
  The result is same for 4.0.10-gamma-max-nt and 4.1.0-alpha-max-nt
- November 20, 2003 at 6:06 pm #15156
  
  Ritesh
  Member
  
  Make sure that the versions of both Source and Target MySQL servers are exactly same. SQLyog uses concat_ws() to generate checksums and different versions of MySQL return different result. For e.g. if you execute the following query
  
  select concat_ws(',',NULL,'',NULL,'A',NULL,'B',NULL)
  
  the results obtained are –
  
  4.1.0-alpha-max-nt – A,B
  
  4.0.15-max-nt – ,A,B
  
  3.23.54-max-nt – A,B
  
  This may cause unwanted errors. Just execute the above query in your source and target MySQL servers and see if the results are same.
  
  Hope this helps.
  
  Ritesh
- November 20, 2003 at 10:20 pm #15157
  
  qstoodley
  Member
  
  Thanks for your persistence on this one.
  
  I have just double checked and yes my source database was 4.0.12 and my target is 4.0.15 and the I do see the differences in the queries that you have produced above.
  
  I will upgrade the source database and let you know how I go.
  
  Thanks again,
  
  Quentin.
- December 1, 2003 at 1:25 pm #15158
  
  Shadow
  Member
  
  SQLyog could issue a SELECT VERSION() command to both servers and warn the user of possible failures if the versions do not match!
- December 2, 2003 at 3:01 am #15159
  
  Ritesh
  Member
  
  Done in SQLyog 3.63!!
- December 2, 2003 at 8:39 am #15160
  
  Shadow
  Member
  
  Great! 😀 We always use the same versions anyway…
Author

Posts