Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am using MySQL Workbench, and when I try to "synchronize" it with my remote database, it keeps detecting some changes to make.

Specifically, the most recurrent ones are:

  • Dropping foreign keys and re-creating the same ones again
  • Changing the collation

I was compliant and executed all the queries given to me (and added the semi-colon that they forgot). MySQL didn't complain and executed them.

However it didn't help, I can run it 20 times in a row, it will still ask the same useless changes.

share|improve this question
Do you use the latest Workbench version? – ypercubeᵀᴹ Dec 27 '12 at 8:02
Yes, 5.2.44 for OSX – nute Dec 27 '12 at 9:30
What version and platform of MySQL Server? – Michael - sqlbot Dec 28 '12 at 17:37
5.1.53 on OSX .. – nute Dec 30 '12 at 12:04

It is possible that this is a bug in MySQL Workbench. You should confirm this with some test database to see if you can replicate the issue and file a bug report.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.