Jump to content

Exporting data from FM6 to mysql?


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

Recommended Posts

You can do a simple export as "tab" delimited file from FileMaker (File -> Export -> as "tab".) You can use the MySQL command-line functions to import a .tab or .txt file into an existing MySQL Database.

<<

mysql> LOAD DATA LOCAL INFILE '/path/pet.txt' INTO TABLE pet;

However, if you are looking for some ready-made FileMaker solution that exports not only data but also SQL that creates a MySQL database... well, I don't know how to do that.

If you would like more infomation about this just drop me a line.

Link to comment
Share on other sites

Thanks, Jbernal.

Well if expart to tab format, how do I get this into MQSQL?

The only way I know to work with MYSQL is via the GUI / application CocoaMySql, which is very nice.

But the only 2 ways to import is either CocoaMySqlDump or CSV file. Non of them work with a TAB file from Flemaker. (I am working on mac OSX)

How can I do this?

Best regards

Oystein

Link to comment
Share on other sites

Well, comma separated looked a bit better, but still does not work.

In the Cocoamysql import window you get the records field content listed vertically on the left column, and on the right you choose with a scrollbar which field in the mysql db you want the content to land into.

The problem is that after (under) the last field in the first record, the list continues with the first field in the 2nd record. And so on.

So here is something missing. It looks like the system is confused about records and fields. They all stay "on one line"...

Any idea?

Oystein

Link to comment
Share on other sites

the list continues with the first field in the 2nd record

I am purely guessing here, but it could be that you need a CR/LF at the end of each record, instead of just CR.

Try massaging the file a bit in TextWrangler (if you can do a sample export FROM MySQL, you can use that as template).

Link to comment
Share on other sites

I have successfully imported from FMP7 to MySQL. I exported to a COMMA seperated text file (not tab). Then... my webhost's mysql manager (called phpmyadmin) has the option for you to select which character seperates the fields for importing a text file.... I just specified a comma and that was it. Your webhost may have a different admin console, I do think it's possible for you to install it yourself on your webspace (phpmyadmin.net is their website). Good Luck. I've recently realized how powerful php/mysql is on the web end of things, filemaker pro still makes more sense internally, so I'm trying to come up with a solution where FMP can auto-update the MySQL db and the two can live in harmony.

Curt

Link to comment
Share on other sites

  • 6 months later...

How do you export to Mysql from filemaker?

I am trying to export to a csv file, but it does not put the field names in the first column, so the mysql won't import.

Is there a way to do this export via odbc?

Please help.

Link to comment
Share on other sites

This topic is 6755 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
×
×
  • Create New...

Important Information

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