MySQL Workbench sync keeps requesting the same changes

MySQLmysql-workbench

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.

Best Answer

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.

Related Question