Database app that can export to mysql? (via phpmyadmin)

benmadrid

macrumors member
Original poster
Jan 21, 2007
91
0
Madrid
I want to put together a database locally that I can then also use on-line as a mysql database - basically I need an app that I can easily make a database with on my mac, then export into some sort of format that I can easily use phpmyadmin to get it into the mysql database on my server. Anyone know the best way to do this? Thanks
 

benmadrid

macrumors member
Original poster
Jan 21, 2007
91
0
Madrid
Thanks. But what I am thinking is how to use for example filemaker, which has a nice friendly UI on the mac, and then exporting from there in a format that can just be put into my mysql DB.
 

SC68Cal

macrumors 68000
Feb 23, 2006
1,642
0
Filemaker uses SQL. You can even use Filemaker to connect to the remote DB. Though, I don't know how well it supports it, since it just added that feature (even though SQL has been around FOREVER, but that's a different bone to pick at)

Though, my two cents is that you should learn SQL rather than relying on a GUI. But that's just my opinion.
 

benmadrid

macrumors member
Original poster
Jan 21, 2007
91
0
Madrid
I agree, and do know a bit of sql/about mysql, but I don't just want to use the database I create for that. I want to use it as a way of organising a large list of vocabulary for other uses as well, and I think using filemaker will be useful for that - I like the search, export etc possibilities it will offer. But I just need to know how to get my data out and into a mysql db. I have installed the trial version of filemaker now but can't see how to do any sql export...
 

pengu

macrumors 6502a
Mar 20, 2005
581
0
Diddily Daddily...
given that Filemaker apparently supports remote SQL databases, why not run MySQL locally, and use Filemaker to create the GUI app for it, and then do periodic dumps from the local mysql to the remote one?

Or, learn a bit of PHP and create a web app and run it locally?
 

benmadrid

macrumors member
Original poster
Jan 21, 2007
91
0
Madrid
given that Filemaker apparently supports remote SQL databases, why not run MySQL locally, and use Filemaker to create the GUI app for it, and then do periodic dumps from the local mysql to the remote one?
Interesting idea, thanks. I'll look into that.