Jump to content

Filemaker Pro to Mysql


khadeo
 Share

This topic is 7275 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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

Link to comment
Share on other sites

  • Newbies

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

Link to comment
Share on other sites

  • 3 weeks later...
  • Newbies

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

Link to comment
Share on other sites

This topic is 7275 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.