ESS TO relationships break when MySQL db is Copied to a new Server?

Discussion created by Oliver_Reid on Jun 6, 2014
Latest reply on Jun 10, 2014 by Oliver_Reid

How does FM remember its Mapping of MySQL fields?



I am moving a Mysql db to a different server and find my FM ESS TO's lose of which field is which w.r.t. relationship links in FM between ESS TO's i.e. the wrong fields are connected when switching the FM app to use the new DSN


I have moved the db Using Navicat's dat transfer facility, which in fact drops and recreates esch table.


In cases - I think where the MySQL field order has changed since the FM mapping was done, the new db fields do not line up.


If anyone has had expierence working around these issues, or under the hood knowledge as to how FM maps to SQL fields, I'd appreciate any insights.

or actual experience, please (resyncing ESS tables does not help)


I have tried a Navicat Backup and restore to the new db, but that also involves dropping and recreating every table.