mysql on another drive
does anyone know how to run mysql on another drive?
that's what I tried to do:
sim -j
cd /mnt/disk2/var/lib
rm -rf mysql/
service mysql stop
killall -9 mysqld
cd /var/lib/
#remember I'm on /var/lib now
cp -a mysql/ /mnt/disk2/var/lib/
mv mysql mysql_old
ln -s /mnt/disk2/var/lib/mysql mysql
service mysql start
#hmm... didn't work
service mysql stop
killall -9 mysqld
service mysql start
sim -j
cd /mnt/disk2/var/lib
rm -rf mysql/
service mysql stop
killall -9 mysqld
cd /var/lib/
#remember I'm on /var/lib now
cp -a mysql/ /mnt/disk2/var/lib/
mv mysql mysql_old
ln -s /mnt/disk2/var/lib/mysql mysql
service mysql start
#hmm... didn't work
service mysql stop
killall -9 mysqld
service mysql start
sim -j
i guess it may be a problem with mysql.sock or something like that...
