Help - Search - Members - Calendar
Full Version: Schema Sync Tool Fails (v7.1 Beta)
Webyog Forums > SQLyog > SQLyog: Bugs / Feature Requests
maxhugen
It looks like there may be a bug in 7.1 beta. The Sync Tool, after clicking 'Compare', displays status:

Comparing tables...
Comparing views...
Comparing stored procs...
Compare unsuccessful

There is no Message, etc.

I should mention, that the source db had a table with one new field in it.

Max Hugen
maxhugen
Tried the Sync Tool with a different db - no problems!
nithin
Hello,

Usually the status 'Compare Unsuccessful' will be displayed situations like MySQL server has gone away or any network problem if use remote connection.

Can I understand from your post that you got 'Compare Unsuccessful' after 'Comparing stored proc' ? If so the tables compare processes was successful otherwise 'Compare Unsuccessful' would have shown just after 'Comparing Tables'.

QUOTE
There is no Message, etc.

Can you please explain this?

We have tested the test case you gave, but not reproducible. So Can I ask you to confirm the issue again with the same test case.
If shows 'Compare Unsuccessful' try 'Compare' again.

And let us know the status.

Are you using direct, ssh or http connection? Connecting to remote host or local host? also tell the MySQL version.

Thanks
maxhugen
QUOTE
Usually the status 'Compare Unsuccessful' will be displayed situations like MySQL server has gone away or any network problem if use remote connection.


This may perhaps have been the problem! I have been experiencing a strange problem, which Peter and Navya have tried very hard to figure out, that seems related to a connection issue. (See http://www.webyog.com/forums//index.php?showtopic=4066).

Today, I had to modify some fields in a third db, and when I sync'd it to the copy on my pc, it worked AOK (as it 'usually' does!).

As I've run the Sync Tool twice since, without any further problems, let's say this issue has 'gone away'. I'll add to this post if it re-appears.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2008 Invision Power Services, Inc.