Sample Header Ad - 728x90

Moved MySQL datadir Now Server Will Not Run!

1 vote
1 answer
2067 views
My problem yesterday (https://dba.stackexchange.com/questions/91483/mysql-alter-table-fails-as-workbench-tries-to-create-existing-table) was caused by /dev/sda2 (/root) running out of space. The cause of this was that, by default, MySQL had installed the DataDirectory (datadir) on /dev/sda2(/root). I therefore recursively copied its contents to /dev/sda3 (/home) after stopping the MySQL server. I also editted /etc/init.d/mysql, /etc/mysql/my.cnf and /etc/apparmor.d/usr.bin.mysqld to reflect this change. After both trying to restart the MySQL server and a reboot the server is still not running. The error.log in /var/log/mysql is also not being appended to. Obviously I have missed something but what? I am running Linux Mint 13.
Asked by MichaelJohn (449 rep)
Feb 10, 2015, 11:31 AM
Last activity: Feb 10, 2015, 03:23 PM