Can’t start MySQL on Ubuntu 12.04 after restored from innobackupex
- by RAH
I can’t start MySQL on Ubuntu 12.04 after restored backup from innobackupex.
Before I tried to restore the db from backup I moved the datadir and got the same problem. With help from google I fixed the problem and got MySQL started.
Ready to set up my new slave, I restored the backup via innobackupex –-copy-path /db/mysql, and now I can’t start MySQL.
I am sure of the following:
In my.cnf the datadir = /db/mysql
The new datadir is chown mysql:mysql.
The /etc/apparmor.d/usr.sbin.mysqld contains:
#/var/lib/mysql/ r,
#/var/lib/mysql/** rwk,
/db/mysql r,
/db/mysql** rwk,
AND
/var/run/mysqld/mysqld.pid w,
/var/run/mysqld/mysqld.sock w,
/run/mysqld/mysqld.pid w,
/run/mysqld/mysqld.sock w,
/var/log/syslog gives me the following info:
http://pastebin.com/1TQGsaBH
What am I missing?
Thanks.
