{"id":1303,"date":"2023-02-15T20:25:39","date_gmt":"2023-02-15T20:25:39","guid":{"rendered":"https:\/\/editjournal.redakt.eu\/faxmodem\/?p=1303"},"modified":"2023-02-15T20:29:30","modified_gmt":"2023-02-15T20:29:30","slug":"mysql-workbench-syncronize-model-table-mapping-not-saving","status":"publish","type":"post","link":"https:\/\/editjournal.redakt.eu\/faxmodem\/blog\/development\/mysql-workbench-syncronize-model-table-mapping-not-saving\/","title":{"rendered":"MySQL Workbench Syncronize Model: Table Mapping not saving?"},"content":{"rendered":"

Problem<\/h2>\n
    \n
  1. \n

    Renamed tables in MySQL model<\/p>\n<\/li>\n

  2. \n

    Need to rename their counterparts on the live server<\/p>\n<\/li>\n

  3. \n

    The model does not recoginse the live tables because of different names<\/p>\n

    \"Example<\/p>\n<\/li>\n

  4. \n

    The standard solution would be to click the mismatched entry, then go to Table Mapping and there choose the right mapping. However<\/strong>, in my case the new mapping wasn't saved, and kept getting lost every time I clicked "OK"<\/p>\n<\/li>\n<\/ol>\n

    Solution<\/h2>\n

    Launch your model and start by using Database<\/em> \u2192 Synchronize With Any Source<\/em> instead of Database<\/em> \u2192 Synchronize Model<\/em>.<\/p>\n

    Sources<\/h2>\n