-
Have a backup.
-
Stop MySQL:
sudo service mysql stop -
Move (or copy) your
mysqldirectory. If you want/mnt/mysqlto be the new directory, do it like this:sudo mv /var/lib/mysql /mnt/ -
Open your MySQL configuration (
sudo vim /etc/mysql/my.cnf) and change thedatadirvalue to your new path (e.g./mnt/mysql) -
Modify your AppArmor configuration:
sudo vim /etc/apparmor.d/usr.sbin.mysqldChange/copy the lines granting access to
/var/lib/mysqlto your new path. Otherwise MySQL will not start. -
Load your new AppArmor configuration:
sudo service apparmor reload -
Start MySQL:
sudo service mysql start
Posted by Arne Hartherz to makandra dev (2011-02-22 16:01)