[cobalt-users] moving MYSQL

[Rahadul Kabir <rkabir@xxxxxxxxxx>]

Hi All,
I just want to check something with you guys and make sure before I do
this job. I have mysql running cobalt RaQ4 system. As Raq4 has 3
partition ( /, /var and /home). I have my mysql databases on
/var/lib/mysql, as cobalt only provide about 190MB of space for /var
directory, I'm running out of disk space on that partition as my
databases are growing. So I'm thiking of moving mysql and all databases
from /var/lib/mysql to /home/mysql (/home has >25 GB). This way /var
would have free disk space.  From all the help and suggestions I have
received from you guys, I come with the following

Steps to move /var/lib/mysql to /home/mysql
1. Shutdown mysql  using safe_mysqld
2. copy the /var/lib/mysql to /home/mysql
3. edit the safe_mysqld and set the datadir=/home/mysql/    (old
datadir=/var/lib/mysql/)
4. startup mysql

Am I missing any steps? Couple of things I'm still confused about. Do I
need to create a symbolic link to something? e.g. /home/mysql points to
/var/lib/mysql, but how could that be If I copy the /var/lib/mysql to
/home/mysql. I think If  change the datadir to /home I woun't need to
set up a symbolic link. Secondly would I still need to copy the
databases to the new location or when I copy the /mysql to /home/mysql
all the databases are also being copied?
thanks so much.

rahad