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
Last activity: Feb 10, 2015, 03:23 PM