Can’t start MySQL on Ubuntu 12.04 after restored from innobackupex
Posted
by
RAH
on Server Fault
See other posts from Server Fault
or by RAH
Published on 2012-10-17T10:26:45Z
Indexed on
2012/10/17
11:03 UTC
Read the original article
Hit count: 714
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.
© Server Fault or respective owner