Hi,

I got a filemaker database on a CD and I work on Linux OS (Mandrake 8.0).

I need to migrate this database to MySQL and I really don't know how to proceed. How can I access the database on Linux ? And how can I migrate it ?

By advance, thanks for helping me

khadeo

Hello khadeo,

did you got it working yet. Because I have the same sort of problem, but in my case I need to synchronize from Linux(mysql) to winNT(filemaker) and v.v. Could you tell me how you solved it?

Thanx in advance Konjo

Hi! I'm very interested in doing the same thing you are attempting to do. I have to support a data driven website that is mysql/php based, but I'm receiving data from a client in Filemaker Pro

I thought it would initially be easy to simply format the data appropriately in FMP, then export as tab-delimited text.

Once in tab-delimited format, one can use mysql's LOAD DATA INFILE feature to bring it into a mysql table.

The HUGE problem at this point is that FMP properly puts tabs between field data in a record but IT DOESN'T PUT A TAB BETWEEN RECORDS!!! - IT PUTS ONLY A HARD RETURN.

I usually have over 20,000 records to import/update each time. I'm going to try to write an Applescript that replaces this hard return with a tab.

let me know if you've had any more success with this.

RhoXS

In tab delimited format, Linux probably expects to see a linefeed between records rather than a return. There should be some text editing utility that you can run the file through to convert returns to linefeeds.