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

Discussion in 'Web Design and Development' started by benmadrid, Aug 6, 2007.

  1. benmadrid macrumors member

    Joined:
    Jan 21, 2007
    Location:
    Madrid
    #1
    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
     
  2. SC68Cal macrumors 68000

    Joined:
    Feb 23, 2006
    #2
  3. benmadrid thread starter macrumors member

    Joined:
    Jan 21, 2007
    Location:
    Madrid
    #3
    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.
     
  4. SC68Cal macrumors 68000

    Joined:
    Feb 23, 2006
    #4
    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.
     
  5. benmadrid thread starter macrumors member

    Joined:
    Jan 21, 2007
    Location:
    Madrid
    #5
    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...
     
  6. pengu macrumors 6502a

    Joined:
    Mar 20, 2005
    Location:
    Diddily Daddily...
    #6
    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?
     
  7. benmadrid thread starter macrumors member

    Joined:
    Jan 21, 2007
    Location:
    Madrid
    #7
    Interesting idea, thanks. I'll look into that.
     

Share This Page