mardi 10 février 2015

Moved MySQL datadir Now Server Will Not Run!


My problem yesterday (MySQL - Alter Table Fails As Workbench Tries To Create Existing Table) was caused by /dev/sda2 (/root) totally running out of space. The cause of this was that, by default, MySQL had installed the DataDirectory (datadir) on /dev/sda2. 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.





Aucun commentaire:

Enregistrer un commentaire