So I'm running a little Slackware LAMP server.
I have a couple partitions:
Filesystem Size Mounted on
/dev/root 49G /
/dev/md1 147G /www #website and stuff
I'd like to store my databases on /www, as it's raided and not likely to be accidentally formatted if I reinstall the OS.
Currently, they're stored in /var/lib/mysql.
What I'd like to do is something like
mv /var/lib/mysql /www/mysql
ln -s /www/mysql /var/lib/mysql
(I probably messed up that syntax.)
Before I do something really stupid, though, I want to filter this idea with you guys.
So, uh, do I have the right mv and ln syntax? Will mysql explode when it encounters a symlink?
Or, even better, is there an option in my.cnf or a similar file that lets me change the directory properly? I didn't see anything, but mysql has a huge man page...
(Currently, there's no data I cherish in the databases, but I figure I should probably learn to do this right before I have to move actually valuable data.)