ODBC nightmare

[rivet]

Just moved a project that has a Filemaker Interface, and a MySql backend, which are connected with Actual Technology's ODBC drive.

After the move of the MySql DB (export from one machine, import into another), all table connections were lost.

In the relationship window, I reconnected the tables to the TOC's but all field mapping was lost. So now I am faces with reconnecting all fields on layouts, scripts, relationships and calculation.

Does, anyone have any tips.

FYI: FMP file, MySql DB, ODBC connection are all named the same as the original setup.