Problems moving the external source from one server to another...???

[angelleye]

I'm working with a MySQL database that I've attached to FileMaker. Currently, the MySQL database is installed my test server at sandbox.mydomain.com. My client's production server is different, of course, and it's as theirlivedomain.com.

We're running FMSA10 on Win2k3. I've got 2 separate ODBC DSN's configured on the server. One that connects to sandbox.mydomain.com and the other that connects to theirlivedomain.com.

During development I've been using my test server's MySQL database. Everything is working perfectly there so now I'm ready to switch it live.

Well, I transferred all of the tables from the test MySQL to the live MySQL and then I simply open up the ESS in FileMaker (File -> Manage -> ESS) and I switch it from one DSN to the other.

Upon doing so everything breaks. When I try and switch to a layout that reads from the MySQL db I get the following error: "The selected columns contain some non-unique values and therefore cannot be used to uniquely identify each and every record in this table or view."

Then when I actually do reach that layout all of the fields say "Primary Key Missing".

I jumped back onto the actual MySQL database to ensure the primary key was still set as it should be and it is. I've got ID fields in all my tables in MySQL that are set as the primary key. Again, the 2 DB's are exactly the same.

Any information on what's going wrong here and how to fix it would be greatly appreciated. Thanks!

[angelleye]

Ah, I had to go in and Sync the 3rd party data and then it asked me to specify which field was the ID field. Looks like that fixed it.

Is there any way to delete messages like this when I find my own solution?