MySQL Workbench Syncronize Model: Table Mapping not saving?

in Development

Problem

  1. Renamed tables in MySQL model

  2. Need to rename their counterparts on the live server

  3. The model does not recoginse the live tables because of different names

    Example of lost Table Mapping

  4. The standard solution would be to click the mismatched entry, then go to Table Mapping and there choose the right mapping. However, in my case the new mapping wasn't saved, and kept getting lost every time I clicked "OK"

Solution

Launch your model and start by using Database → Synchronize With Any Source instead of Database → Synchronize Model.

Sources

#mysql-workbench