How to move a MySQL database to another partition

1) Create the database in MySQL

2) Stop the MySQL database

"/etc/init.d/mysql stop"

3) Move the folder to the new directory to the new partition (/your/new/location/.

4) Give MySQL ownership of the directory

"chown -R mysql:mysql /your/new/location/MySQLdatabase"

5) Create a Symlink between the old directory and the new created dir.

"ln -s /your/new/location/MySQLdatabase /var/lib/mysql/MySQLdatabase"

6) Edit the AppArmor? file (Most often located at: /etc/apparmor.d/usr.sbin.mysqld)

Add the location of your database to the file. " /your/new/location/ rw," " /your/new/location/* rw,"

7) Restart AppArmor?

"service apparmor restart"

8) Restart the MySQL database

"/etc/init.d/mysql start"

More information on: ​http://mysqlhacker.com/kabir/tablespace/distributing-your-mysql-database-across-disk-partitions.html ​http://www.ubuntu-howto.info/howto/how-to-move-mysql-databases-to-another-location-partition-or-hard-drive ​http://chrisjean.com/2010/05/21/mysql-error-1018-unable-to-follow-symlink-in-ubuntu/