Trouble after restoring backup v2.1.3

Hello guys,

I am having an annoying issue here and would like to know if you have some tips for me.

After restoring the backup i cant put the mysql up again the service just stucks at the start and restart commands.

Here are the steps i am doing:

[B]sudo innobackupex --compress --ibbackup=xtrabackup --user=root --password=pass /home/ubuntu/Backup/ => for backup

Uncompress then:[/I][/B]

[B]sudo innobackupex --apply-log /home/ubuntu/Backup/my-backup-folder => to prepare

Shutdown MySQL process, clean datadir then:[/I][/B]

[B]

After doing this MySQL service seems completely broken, any ideia of that could be going on?

Thank for the help and have a nice day.

Hi,

Can you provide full error log, MySQL/Percona Server version?

The messages that i got repeatedly in log are:

InnoDB: File name ./ibdata1
InnoDB: File operation call: ‘open’.
InnoDB: Cannot continue operation.
130607 20:33:57 [Note] Plugin ‘FEDERATED’ is disabled.
130607 20:33:57 InnoDB: Initializing buffer pool, size = 8.0M
130607 20:33:57 InnoDB: Completed initialization of buffer pool
130607 20:33:57 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.

and

File name ./ibdata1
InnoDB: File operation call: ‘open’.
InnoDB: Cannot continue operation.
130610 15:44:45 [Note] Plugin ‘FEDERATED’ is disabled.
^G/usr/sbin/mysqld: Can’t find file: ‘./mysql/plugin.frm’ (errno: 13)
130610 15:44:45 [ERROR] Can’t open the mysql.plugin table. Please run mysql_upgrade to create it.
130610 15:44:45 InnoDB: Initializing buffer pool, size = 8.0M
130610 15:44:45 InnoDB: Completed initialization of buffer pool
130610 15:44:45 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.

[COLOR=#B22222]Np i found out that doing chmod 777 to /var/lib i could bypass the error, later i figured that after the restore the files inside that folder was owned by root.

Changing the permission to the files or changing the owner to mysql solves the problem.

I am still posting here to help some other people that may face the same problem.

Hi, I’m glad that you found out the problem and solution for it. :slight_smile: