Solved

Export or sync Filemaker fields and data to MySQL database

Posted on 2014-03-03
1
1,613 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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
FM - Setting Up a Table of Sales Reports 2 8
sort in mysql based off of query param 4 24
mysql date time 14 32
two ways encryption with php 3 28
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…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

831 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