[Ritesh]

Which version of MySQL are you using?

Can you cut-n-paste the result returned by “show create table `db`.`table`”?

[Ritesh]

We are working on this issue and will revert back soon.

[Ritesh]

SQLyog does the export in the main thread. Being a single threaded app, it prevents all the GUI operations to be completed.

We plan to fix this issue in SQLyog 4.1.

HTH

[Ritesh]

Currently, you cannot schedule generation of Batch Script in SQLyog. The only thing that can be scheduled are:

• Database Sync Wizard (Tools->Power Tools->Database Sync Wizard)
• SQLyog Notification Services (Tools->Power Tools->SQLyog Notification Services Wizard)

With that I would like to say that the above feature is planned for SQLyog 4.1.

To import a batch script, use Tools->Execute Batch Script…

[Ritesh]

Yes.

[Ritesh]

The error you are getting simply means that you are giving wrong password.

[Ritesh]

I am not sure about what you mean by data reconciliation.

Can you explain it with an example? I am sure SQLyog Job Agent will do the job for you.

[Ritesh]

Quote:

Does the structure of the two databes, tables, field names have to be the same in order to syncronize?

Yes.

Quote:

Both started with 10

When syncronized would both now be 6?

or

Will they both be 4?

The data from source database will be updated to the target. Assuming that DB1 is the source – the data will be 8 in both source and target after the sync.

[Ritesh]

I have mailed you the details.

[Ritesh]

The above feature has been added in v4.0 Release Candidate 1. Check out: http://www.webyog.com/forums/index.php?act…&st=0#entry3909

[Ritesh]

Check out the last post at http://www.webyog.com/forums/index.php?act…ct=ST&f=2&t=977

SQLyog Enterprise is what you are looking for.

[Ritesh]

No.

I think a scripting language like PHP is a better option to handle such problems.

[Ritesh]

Please upgrade to SQLyog 4.0 BETA.

More information on SQLyog 4.0 can be found at:

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

[Ritesh]

Good news! This feature will be available in v4.0.

[Ritesh]

I hope you are using SQLyog 4.0 BETA 6 in your laptop.

From your answer it looks like that there is a conflict of libmysql.dll. 🙁

Please search for libmysql.dll in your computer and delete all instances of libmysql.dll except the one in the SQLyog installation folder.

[Author]

Posts