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. 