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


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/ r,
   /your/new/location/** rwk,
}}}


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/