[Ritesh]

2-way synchronization is planned for SQLyog 3.7

[Ritesh]

Hmmmm..

Maybe you can put it in the MySQL Bug List :huh:

[Ritesh]

Which page of the wizard is giving the error?

It may happen that you are importing a very big database. This may take some time 😀

[Ritesh]

Great 😀

[Ritesh]

You need to save your sync job in a file ( e.g. c:job.xml ). Then create a batch file with the following contents –

c:program filessqlyogsja -lc:sja.log c:job.xml

Create a shortcut for the batch file in your desktop. Whenever you double click on it, the agent will start up and perform the sync.

[Ritesh]

First of all change the table handlers to InnoDB table type. For more information about InnoDB table handlers visit http://www.innodb.com

There is a very nice tutorial on setting up FK using SQLyog at http://www.weberdev.com/ViewArticle.php3?ArticleID=352. Check it out.

[Ritesh]

This is strange!

Can you send us the XML file at [email protected]. It would be great if you can send some sample data too.

We will setup your environment out here, and try to reproduce the bug.

What are the contents of c:log.log?

[Ritesh]

Does the error occur ONLY when the source database is your local server and the target database is your remote server? Does it occur if you interchange the source and the target?

[Ritesh]

Can you paste the output from sja when you are running it with correct option i.e. without a space between -l and the log file?

[Ritesh]

While executing sja from the command line dont put a space between -l and the log file name.

This means that instead of

Code:

sja -l c:log.log c:sync.xml

use

Code:

sja -lc:log.log c:sync.xml

We are going to fix this bug soon.

If you are able to sync two databases from command line when using the correct option please let us know.

[Ritesh]

SQLyog logs all the queries in the History window. Just check out the query that is returning error :huh:

[Ritesh]

Done in SQLyog 3.63!!

[Ritesh]

It will be even ask you whether you want to remove the Personal Folders automatically using the uninstaller 😀

I have forwarded your request to my development team.

[Ritesh]

Great 😀

[Ritesh]

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

[Author]

Posts