Export or sync Filemaker fields and data to MySQL database

MarkJulie
MarkJulie used Ask the Experts™
on
I have a large FMDB with approximately 110 fields that need to be created in a MySQL database. If I have full privileges for the MySQL db, is there a way to export the FM fields and data to import into MySQL or to sync the FM fields directly to MySQL? The slow process is to had create every field in a new MySQL table, but automation would save errors and time.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Co-Owner / Developer
Commented:
The quickest and easiest would probably be to just do an export from FileMaker to a csv file and then import that CSV file into MySQL through phpMyAdmin or a tool like Navicat.

Once you have all the matching fields, if you need to sync up rather than export/import all the time, you could setup FileMaker External Data Sources and then write some scripts in FM to automatically sync up with MySQL.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial