Question
Since restoring from a backup mySQL won't start
Hello there,
I have a Ubuntu 12.04.3 LTS (GNU/Linux 3.8.0-29-generic x86_64) droplet which I ballsed up by attempting to upgrade Ubuntu.
So I restored it to a backup from 1 week ago. However, I can’t for the life of me seem to get mySQL to start. After restoring mySQL comes up for a matter of minutes and then dies refusing to start again.
Looking in syslog, it seems to die when this comes up:
Apr 3 23:47:25 localhost kernel: [ 360.410338] type=1400 audit(1428101245.773:24): apparmor=“STATUS” operation=“profilereplace” name=“/usr/sbin/mysqld” pid=2456 comm=“apparmorparser”
Trying service mysql start come back with this:
start: Job failed to start
Does anyone have any idea what might be happening please?
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
×
try:
dpkg-reconfigure mysql-server-5.5
Thanks I’ll give that a go
Unfortunately that did not work:
Skipping profile in /etc/apparmor.d/disable: usr.sbin.mysqld
start: Job failed to start
invoke-rc.d: initscript mysql, action “start” failed.
Try running MySQL manually, does it output any errors?
If I try sudo -u mysql -g mysql mysqld I get:
150404 19:29:06 [Warning] Using unique option prefix keybuffer instead of keybuffersize is deprecated and will be removed in a future release. Please use the full name instead.
150404 19:29:06 [Warning] option ‘threadstack’: unsigned value 65536 adjusted to 131072
If I try just mysql I get:
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ’/var/run/mysqld/mysqld.sock’ (111)
I don’t suppose you ended up finding a solution to this problem? I am encountering it right now with no luck so far.
Just out of curiosity, what was the problem when upgrading Ubuntu?
I am just wondering if going ahead with the Ubuntu upgrade might be a better approach. There are a few tweaks to make, but its not that complex.