Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1914
  • Last Modified:

Export or sync Filemaker fields and data to MySQL database

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.
0
MarkJulie
Asked:
MarkJulie
1 Solution
 
Andrew AngellCo-Owner / DeveloperCommented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now