mysql on remote server

[michele]

Hello,

I need to get data in (from a fm db) and out (to a fm db) a mysql database on a remote server.

FtpIt would be an option,uploading mysql instructions (created with calculation fields) on text files where the server picks them up (php instructions)or the mysql creates text files using php that are picked up by the fm db using ftp-it or is there another way?

Anybody ever had the need to work with a mysql datase on a remote server?

Please give me advice (and no, I can't change the remote database to filemaker -) )

Thank you for reading and eventually answering my question.

[Steve T.]

Hello, m! If I understand correctly, you have a MySQL db and a FileMaker db and want to transfer data back-and-forth between them? Are you synchronizing the data so they match exactly, or are they separate db's and just sharing some small information sets only sometimes, and how often do they do this?

I have not set anything like this up yet, but I'm headed in that direction and was going to look at writing PHP scripts to do this, but I will be going FM-SERVER <==> MYSQL-SERVER whereas I would guess you are looking for FM-CLIENT <==> MYSQL-SERVER, no?

I think there are also a number of synchronization strategies out there using various technologies as well as some commercial product options, but I'll be working on the cheap and doing it myself. Et vous? Bonne chance!

--ST

[Garry Claridge]

A simple method is to export the required data as a TAB/Comma delimited file, then Upload via a Form, on the site, which Submits to a PHP scipt which then loads the MySQL database.

You could automate the export and upload with Applescript. (Or, some CURL scripting.)

As Steve said this would depend on the amount, and timing, of the required synchonization.

All the best.

Garry

p.s. Except for the Applescript, this is how one of my clients does it.

Edited September 13, 2005 by Guest