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

[benmadrid]

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

 

[SC68Cal]

MySQL has functions that do just that.

http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html

It'll give you either a CSV or plaintext file that will contain the commands to create the database on the new server.

 

[benmadrid]

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]

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]

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]

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]

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.