On Tue, 2006-10-10 at 23:01 +1000, Peter Kiem wrote: > Hi Jim, > > > > Now normally I just move /var/lib/mysql to /home/mysql and symlink > > > it. > > > > Um... why? This seems like it would be more trouble than it's worth. > > and with the symlink, I don't see the benefit. > > The reason I move it is because I usually make my systems with a 'small' > / partition (say 10GB) and a large /home partition. > > It is very easy to have large MySQL databases sitting in the default > location then use up all space on the / partition which causes all sorts > of havoc. > > By moving it off to the /home partition it is moved to where the > majority of the space is available and away from system data. MySQL > databases are user data and should be in the user area. > > The symlink allows you then to just start MySQL without changing any of > the config files and anything else that expects it to be in > /var/lib/mysql can still find it. While you're reading up on the mount command as suggested earlier, keep an eye open for the fact that you can mount any portion of a directory structure over another. This will give you the "freedom" to put stuff in /home and leave the config files and SELinux (? I think, I'm still total n00b at that) unchanged. > <snip> BTW, I agree that user data belongs in a user area, not system area. I would move it for that reason alone. HTH __ Bill