install mySQL, partition question
 

i am about to set up a mysql server, i would assume that the db itself should have its own partition. Which one is that? can anyone tell me the correct way to set it up? thanks

I dont think that db itself have its own partition. I use slackware as my server, and it has mysql so u dont have to compile it. I bet u that most of the distros have Mysql by default. U need to select it to install it.

You can put the database on its own partition if you want to. It might help you, for instance if you want to use software-RAID for speed or reliability. (http://www.tldp.org/HOWTO/Software-RAID-HOWTO.html) You probably only want to do this if you have a very high load on the database, though, as it can be very expensive in terms of disk space.

The default database location is /var/lib/mysql (installing from RPM), which is used for database files and logs. /usr/local/var is used by default when building from source. (http://dev.mysql.com/doc/mysql/en/In...n_layouts.html)

The installation guide is at http://dev.mysql.com/doc/mysql/en/Installing.html