Exporting data from FM6 to mysql?

[Oystein Sevag]

Is there an easy way to export my filemker 6 databases to MqSql ?

I have many filemaker databases and want to move this over to mysql for web reasons. Any idea how to do that?

Very thankful for advise!

Oystein

[jbernal]

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.

[Oystein Sevag]

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

[Lee Smith]

Change the extension to .csv and see if that doesn't work.

Lee

[Oystein Sevag]

Hi Lee,

I tried to export as .tab, and then change exctention to .csv.

This did not work. It seems to be "90 degrees wrong", every post from FM goes to one filed in Cocoamysql....

Should i try another of FMs export formats for this?

[Lee Smith]

Hi

[comment]

Filemaker can export in CSV format. Choose 'Comma-Separated Text' when exporting.

[Oystein Sevag]

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

[Lee Smith]

Have you looked at FileMaker's Online Help for SQL?

There seems to be a lot there on how to interact with SQL and ODBC, etc.

Lee

[comment]

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).

[Oystein Sevag]

Sorry, but can you say a little more about Textwrangler. Is that an applicatin - available for OS X? I am on mac.

Thanks!

[comment]

http://www.barebones.com/products/textwrangler/index.shtml

[pigslow]

I export from a filemaker 7 db to a MySQL 4.0 db. I am not sure how different it would be with the version difference.

I Export Records as a Path/filename.txt with the filetype as a *.tab and it works.

[Curtis_B]

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

[J]

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.