Thanks for the response and for suggesting the manual and the books. I will take a look in to the manual for now.

My host provider only supports MySQL4.1 so I guess for now I'll have to stick with that version.

I still need to set up the database from scratch, but i'm using JSP and Java to interact with the database.