Database Synchronize always out of Synch
I have a live Database that I built with MySQL Workbench 6.0 (I just upgraded to the latest version) a number of months ago. While I was able to get the synchronize (Me->DB) working in the past, it was always updating the same routines again and again, even when there weren't any changes. I overlooked this since there were no errors and the rest of the synchronization worked.
Now, I can't have it synchronize without the need for me to manually delete routine after routine - and this process takes forever as it'll sit on "fetching triggers" for ~1 minute or so with each synch. Note it's getting stuck on thinking it needs to update routines that have been there for months. I have NO idea why this is happening (note I've always used the same base model).
There aren't any "errors" other than things being out of synch, and my client-side model is the "master". The problem I have now is I don't know how to synch things. I did a reverse synch to a new model and most of the routines were missing - even though they are in the live the database! So not sure what's going on.
Any recommendations on how to resolve this synchronization issue?
Subject
Views
Written By
Posted
Database Synchronize always out of Synch
1396
April 22, 2014 05:06PM
654
April 24, 2014 02:34AM
625
April 24, 2014 08:57AM
533
April 25, 2014 01:17AM
447
April 25, 2014 06:58AM
543
April 26, 2014 11:19AM
515
April 26, 2014 11:31AM
536
April 28, 2014 01:41AM
454
April 29, 2014 05:43PM
507
April 30, 2014 04:22AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.