Synchronization Bug

[bass]

Hi,

I have 2 DB's. Now I want sync one table of these.

Table of first DB has a INDEX that second DB don't has.

The “Database Syncornization Tool” dislplays the difference,

but when I click con “Sync (Clipoard) >>>” of first DB, the

SQL Script say's “drop key 'name'” and not ” add index …” for

the second DB!!

Regards,

Bass

PS: for global use…maybe it's better to change “drop key …” into “drop index….”

[CalEvans]

Have you tried it the other way? Switch the databases?

And key is the proper SQL term in this case, not Index.

=C=

[bass]

when I switch the DB i noticed that sqlyog dislpays

a property of first DB on the second DB window.

and so sqlyog confus the DB's and doesn't the right changes:

sample:

table1 has uniqe key 'key1' (as First Database)

table2 has key 'key1' (as second Database)

sqlyog displays uniqe key on the second DB window !!!

…and so, when I click on “<<< Sync (Clipboard" (I want change key1 of table1 into normal key), it generate: alter table 'db'.'table1' drop key 'key1', add unique key 'key1' ('field1') this generates the same key that table1 had before the alter-query Hope this helps, bass

[Ritesh]

Click Sync ( Clipboard ) for the second database 😀

[Ritesh]

What I meant to say is instead of switching the database in the dropdown combo box, click on the Sync ( Clipboard ) for the second database

HTH

[bass]

I did it !! That's the problem!

[bass]

…there is the same problem in both ways….

the gernerated sql statement changes the key propertys

for the wrong table… 😉

[bass]

…and for CalEvans:

sorry my question but when KEY is the proper SQL Statement….

why I can't found it on mysql documentation?!?!?!?

whats the differences between INDEX and KEY ???

[url=”http://http://www.mysql.com/doc/en/ALTER_TABLE.html”%5Dmysql documentation[/url]

[bass]

Sorry here is the right URL…

[Ritesh]

Can you send me the SQL Batch script for both the databases, so that we can reproduce the bug ( if there are any ) out here :huh:

[Author]

Posts