== 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/