maandag 7 mei 2012

Moving mysql data folder


check your mysql setup , and maybe take a backup

stop mysql
$/etc/init.d/mysql stop

move the data folder

$mv /var/lib/mysql /var/db/

create a symlink so everything can find teh new data folder

$ln -s /var/db/msql /var/lib/mysql


edit the apparmor file

$nano /etc/apparmor.d/usr.sbin.mysqld

find the  2 entries that point to /var/lib/mysql and change the appropriately (in my case /var/db/mysql)

restart apparmor
$/etc/init.d/apparmor restart 

start mysql
/etc/init.d/mysql start 


check if everything is ok