15Apr/103
Changing Mysql data directory require change to AppArmor
After a bit of googling and hair-pulling, I realized that if I just changed the datadir directive in my.cnf will cause mysql start to fail on Ubuntu. The other thing is to add permissions to apparmor for mysql to access the new data directories.
Steps
1. sudo vi /etc/apparmor.d/usr.sbin.mysqld
2. Add
/newdir/ r,
/newdir/** rwk,
3. sudo /etc/init.d/apparmor restart
4. sudo /etc/init.d/mysql restart
If that still does not work, check the nix permissions to be sure mysql is owner and group for the new directory recursively.
chown -R mysql:mysql “new datadir path”
March 13th, 2012 - 05:59
Thank you very much. Finally I configured the tables on different volumes.
February 27th, 2011 - 11:24
While adding the new lines, also comment out the original lines starting with, /var/lib/mysql
Also set the proper permission for the new mysql datadir with the command,
chown -R mysql:mysql “new datadir path”
February 27th, 2011 - 11:31
You’re right, I should add that command in there also. Thanks.