[Mahesh]

HI,

It shows CPU usage but not processlist.

We are calculating the values from /proc/.

First you have to Give Linux host address and authentication details in Register Server– SSH server details section.

Then Goto Monitors and Advisors page, will show the counters and values receptively ( see the screen shot).

[Mahesh]

Are there any warnings, after importing?

Please tell program version as well as MySQL version ?

Also, can you try it from a commandline client ?

[Mahesh]

Quote:

job doesn't do the one record update that I am testing with.

There is no change in executing a job from GUI or from command line ( using windows scheduler etc..).

Are you sure that it is not updating ? you can verify this by selecting a target table ( click on table data tab — Press Refresh button).

See the values before syncing and after sync.

[Mahesh]

Migration Toolkit feature is Available only in Trial and Enterprise version.

After installation — Open SQLyog

1) Connect to server and then

2) Select Powertools menu — Migration Toolkit ( for more information please go through help file)

Thanks,

Mahesh

[Mahesh]

Hi,

We have fixed this issue in this special not released build ( v 2.83 n1).

To download,

http://www.webyog.com/downloads/betas/not_….8.3-0.i386.rpm

Please verify and let us know the details.

[Mahesh]

It is still not reproducible for us,

Can you please attach a screen shot while getting this error ? OR is it same as attached below ?

[Mahesh]

This issue is added in our issue tracker here,

http://code.google.com/p/sqlyog/issues/detail?id=911

Behaviour should be consistent and BACKTICKS character should be ignored if there is any.

[Mahesh]

One more point — We should replace all job files without “`” character in column tag.

[Mahesh]

HI,

How u created a job file? Using GUI OR Manually?

Please remove “`” character from table name and column name because we are adding this character internally through code and make

…

…

Hierarchy and then add tag and try whether it is working for you ?

I think we have to add some examples of datasync job files for different sync action types.

[Mahesh]

HI,

created a table `auth` as mentioned above and perform sync operation. ( generated sql script with insert as well as update statement and worked successfully).

It is not reproducible for us.

I have attached a generated sql script and job file below.

[Mahesh]

We have this feature request added here,

http://code.google.com/p/sqlyog/issues/detail?id=417

[Mahesh]

HI,

Issue Confirmed.

We have added this in our issue tracker.

Thanks for reporting.

[Mahesh]

Yes you can add multiple counters ( reports ) for a group as well as you can add more than one group in the same mycounters.js file.

(see the screenshot attached below which shows an example of two counters in a same group).

[Mahesh]

Quote:

However, sja.log and sjasession.xml only have the error, not the query that caused the error (and the error is a syntax error). Is this a known bug?

It wont show which query caused a problem but for syntax error it should show where the problem lies for example,

Error 1064 “You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near `column_name`”, if column name is a culprit.

what it shows in sja.log file when you got this error?

Quote:

This same job file works with sja 6.56.

Then we need a table structure with data.

[Mahesh]

Issue confirmed using Linux sja

If the sja is not able to connect to server then it neither run a job nor show any error ,

It shows like ” Sync started at …..”

[Author]

Posts