Forum post
script for import ODBC from mysql
Forum post posted January 5, 2009 by steelbut, last edited February 9, 2012
199 Views, 1 Comment
Title:
script for import ODBC from mysql
Your post:
Does anyone know the best way to import data from a remote mysql database to a local computer with server advanced that serves a small office.
When I bought server 9 advanced I thoguht it would be easy to time a script to get data through ODBC from a remote mysql database but the many many support calls I made said "no".
Any idea how to get the data in a timed manor - say every hour. The server gets requests from many web site "quote pages"
Also (this might be questions #2 but) can you open a field in filemaker to sync / change data directly with a remote mysql database? For instance to change a price in a pricing cataloge?
Thanks, steelbut (larry)
Answer
Sync'ing has to be scripted 'by hand' which can become quite hairy if data flows in both directions.
Jens
Be the first to like this
|
Sign in to "Like"