Databases

[Slime101]

Does anyone know anything about database design and integration, with specific reference to getting data out of one, and into another (filemaker to mysql)

[si_guru]

Is for MAC?

Does this help? http://www.macupdate.com/info.php/id/10736

[Slime101]

Its not for MAC no, but i will have a read as it might help. As it happens i think i have worked it out anyway but a guide to point me in the right direction for the missing bits would be handy!!!!

My SQL resource book is being particually useless and should go back to gathering dust i think!!!

[TheGurkha]

If you are going to be working with MySQl you should get hold of Navicat or the MySQL control panel (not sure of the name, have to check their website). These are graphical packages (open source I believe - certainly the mysql one is) that allow you to work with databases through a GUI, makes life so much easier. You can also enter and execute SQL commands and they have import and export facilities that might be what you're looking for.

Just checked the MySQL one is called administrator and you need MySQl 4.0 or later.

http://www.mysql.com/products/administrator/

[Slime101]

I use phpmyadmin for administering the databases on the server but thanks for the reccomendations.

As far as i can work out i can export a comma seperated file which i can then manually create a database and import the file into the database table, which is good. I even have the import script ready so all i need to write is the query strings and stuff for the front end.....oh and the rest of the database and import stuff.

[defuzz]

I'd stick with PHPMyAdmin, best MySQL tool I've come across, I get to use SQL Server at work which is a lot more powerful but a lot more complicated to set up, fortunately someone else does that, I just connect the web pages to it.