Solved

Export or sync Filemaker fields and data to MySQL database

Posted on 2014-03-03
1
1,623 Views
Last Modified: 2014-03-04
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
Comment
Question by:MarkJulie
1 Comment
 
LVL 11

Accepted Solution

by:
Andrew Angell earned 500 total points
ID: 39902393
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

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question