I am running Filemaker Server 10. I have written a script that runs every hour to update the MySQL tables based on a found set that determines which records are new or in need of an update. The script then uses the MySQL ODBC connection to push the field contents onto the MySQL table record by record and field by field. There are roughly a dozen of these tables, and the total execution time is around 40 minutes.

Intermittently, we are getting ODBC errors, usually "[MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on '[server name]' (10048)." Various tests have led us to believe that our approach is working too fast and is not opening and closing the MySQL connections properly, thereby causing these errors to be thrown. Is there a better way to do this, such as setting up a virtual workstation to do an import and export of the records? Or perhaps a different approach, like a scheduled PHP script that runs over the ODBC and pulls the Filemaker data into the MySQL database?

Any input you can give would be appreciated.

I personally use PHP for this. You do need to break down your record sets to be effective though.