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

Related posts about mysql

Related posts about ubuntu-12.04