[Ritesh]

Work on SQLyog Max is going on. We plan to release a Mac port by end of Jan 2005. First beta of SQLyog Max for Linux and Windows is already available.

Check out: http://www.webyog.com/forums/index.php?act…ct=ST&f=2&t=883

[Ritesh]

This bug is already fixed in SQLyog Enterprise 4.0 BETA 6 😀

[Ritesh]

The bug has been fixed in SQLyog Enterprise 4.0 BETA 6.

For more information check out: http://www.webyog.com/forums/index.php?act…&st=0#entry3840

[Ritesh]

The bug has been fixed in SQLyog Enterprise 4.0 BETA 6.

For more information check out: http://www.webyog.com/forums/index.php?act…&st=0#entry3840

[Ritesh]

Aha! so you were selecting the wrong server.

By default, SQLyog will show last used connection parameters. You can select an existing connection details from Saved Connections dropdown.

This is a minor interface issue which we plan to improve upon in SQLyog 4.0 BETA 6 😀

[Ritesh]

Any file comparison/merge utility like Araxis Merge should do the job for you.

HTH

[Ritesh]

One thing you can try is execute DB->Empty Database… in the target server and run the Sync process. SQLyog will create the table(s) in the target server and insert all the data from the source to the target.

[Ritesh]

Quote:

Field count not equal for '`countries`' table

This means that field count in the source and target servers are not equal. Considering the steps you are following, this looks strange.

Can you execute

Code:

show fields from `countries`

in both servers and see if there is any difference?

Quote:

Column NAME mismatch for '`settings`' table

Is the column NAME differentiated as VARCHAR and CHAR in the two servers?

[Ritesh]

Database Sync Tool (SJA) requires the structure of source and target tables to be exactly same. Are you sure the tables countries and settings are having the same structure and column count?

Can you cut-n-paste the CREATE TABLE… stmt. for the tables out here? Can you tell me the versions of your source and target MySQL servers?

Quote:

If I execute SELECT on any table in the destination database mysql returns an empty set.

But you said:

Quote:

All tables were synchronized except two

I believe you are getting empty resultset only for the above two tables.

[Ritesh]

This is a bug with SQLyog.

While adding up server names in the drop-down combo, SQLyog does not consider SSH connections. It will be fixed in BETA 6.

[Ritesh]

SJA does a string comparison of the version numbers returned by MySQL and displays a warning.

You can forget about the warning. Everything will work smoothly for your configuration 🙂

HTH

[Ritesh]

This issue has been resolved in SQLyog 4.0. SQLyog 4.0 has got a completely new and improved editor.

For more information on SQLyog 4.0 BETA, please visit:

http://www.webyog.com/forums/index.php?act…ct=ST&f=2&t=977

[Ritesh]

Hello Shadow,

Are you able to reproduce the error?

[Ritesh]

😀 😀

[Ritesh]

SJA, the command line tool used by SQLyog to send notifications takes a XML schema as input. This schema contains all the information required by SJA i.e. source database informations, smtp server informations etc.

The wizard in SQLyog generates this schema temporarily and deletes it after SJA has completed its job. You can ask the wizard to save this schema in the second last page where it asks you – “What do you want to do with the job?”. The wizard will save the schema in the filename specified by you in the last page of the wizard.

With the schema file we will be in a better position to find and solve the bugs (if there are any). You can mail them to me at [email protected]

[Author]

Posts