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.

  • 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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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