[Ritesh]

Can you tell me your source and target MySQL versions?

[Ritesh]

Can you run this script from the command line using 3.63 ( Release )

sja

and cut-n-paste the output out here?

[Ritesh]

3.63 has been released

[Ritesh]

No.

You have to install SQLyog in a different machine and try it out.

[Ritesh]

3.63 RC1 that has this bug fixed has been released. Get more information at http://www.webyog.com/forums/index.php?act…st=0&#entry1942

[Ritesh]

Great. Waiting for them.

[Ritesh]

Quote:

The most significant of the bugs I've encountered is this: In the Insert / Update Table window, if I use Ctrl-End to move to the bottom of the window of data, the program crashes instantly.

Tested on XP SP1 with a table of around 15 columns. Works.

Is this happening everytime? Can you send me your table structure and data so that we can test it on our side.

[Ritesh]

Use

tar -xzvf sja.tar

We have tested this tool with tables having 15 columns and 10 million rows.

HTH

[Ritesh]

We will be releasing SQLyog 3.63 soon that will have this bug fixed.

[Ritesh]

Download MySQL from http://www.mysql.com and install it.

MySQL is FREE !!!

[Ritesh]

Can you give more details ( step by step ) about the error?

[Ritesh]

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

[Ritesh]

Are you able to schedule any other software using the Task Scheduler? Just try running it from the command line once.

Make sure that you are giving correct details in the task scheduler.

[Ritesh]

They have been removed from the toolbar. The options are present in the File menu.

HTH

[Ritesh]

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

[Author]

Posts