Database Setup

They have: 12 posts

Joined: Aug 2002

I am new to setting up databases to a web site. I know SQL and how to setup tables and create the database by I get confused when I have to set the database up on the servers. Can anyone recommend a good book on database processing on the web? My guess would be that MySql databse would be a good starting point because it is an open source database and is free. I can't afford to buy the big commerce type database to practice with. So any suggestions would be helpful. I am the type that needs to read and see some examples to learn.

Thanks.

He has: 1,016 posts

Joined: May 2002

http://www.mysql.com/ - You'll find both software and install documentations there. If you later run into problems, feel free to ask us here. Good luck.

mairving's picture

They have: 2,256 posts

Joined: Feb 2001

O'Reilly also has a good book on MySQL and MSSQL. It gives some general SQL and also a lot of reference tables.

Peter J. Boettcher's picture

They have: 812 posts

Joined: Feb 2000

MySQL is great because it is free but it's not going to expose you to all the database world has to offer (yet!), like stored procedures, triggers, etc.

If you're going to use MySQL then the link already provided is probably the best place to start. If you've got a spare machine to play with just download it and start playing around and remember to have fun!

PJ | Are we there yet?
pjboettcher.com

Busy's picture

He has: 6,151 posts

Joined: May 2001

there are a few sites that offer Apache/PHP/MySQL bundles so you can play/test on your own machine, I got mine from http://firepages.com.au
they also have Active Perl and MySQL Front and the manuals for all

Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.