I am using MySQL on ubuntu 8.04.
I followed this link
to change the data directory of MySQL.
After stopping MySQL: sudo /etc/init.d/mysql stop
I make a new directory: sudo mkdir /media/disk/MySQL_data
then change the ownership of new directory, sudo chown mysql:mysql
and copy all data to the new directory, cp -r -p /var/lib/mysql/*
/media/disk/MySQL_data/ and deleted all files like ibdata1,
ib_logfile0, and ib_logfile1.
I then edit /etc/mysql/my.conf and update the "datadir" to my new
directory. I also update /etc/apparmor.d/usr.sbin.mysql so that news
lines with /var/lib/mysql replaced by /media/disk/MySQL_data are
However, after sudo /etc/init.d/apparmor reload
I try sudo /etc/init.d/mysql start
* Starting MySQL database server mysqld
If I change the "datadir" line in /etc/mysql/my.conf back to the
original one, I can start MySQL successfully.
I think I have done everything needed to change MySQL data directory.
Why am I still getting this error? Where can I start to look for the causes?