# Trouble after restoring backup v2.1.3

**URL:** <https://forums.percona.com/t/trouble-after-restoring-backup-v2-1-3/2747>\
**Category:** Percona XtraBackup\
**Created:** [June 10, 2013, 3:59pm UTC](https://forums.percona.com/t/trouble-after-restoring-backup-v2-1-3/2747 "2013-06-10T15:59:39Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Peter\_Thorun](https://avatars.discourse-cdn.com/v4/letter/p/4bbf92/32.png) [@Peter\_Thorun](https://forums.percona.com/u/Peter_Thorun)\
**Post date:** [June 10, 2013, 3:59pm UTC](https://forums.percona.com/t/trouble-after-restoring-backup-v2-1-3/2747/1 "2013-06-10T15:59:39Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![niljoshi](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/niljoshi/32/16889_2.png) [@niljoshi](https://forums.percona.com/u/niljoshi)\
**Post date:** [June 10, 2013, 10:17pm UTC](https://forums.percona.com/t/trouble-after-restoring-backup-v2-1-3/2747/2 "2013-06-10T22:17:16Z")

</div>

Hi,

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

---

<div class="post-metadata">

**Author:** ![Peter\_Thorun](https://avatars.discourse-cdn.com/v4/letter/p/4bbf92/32.png) [@Peter\_Thorun](https://forums.percona.com/u/Peter_Thorun)\
**Post date:** [June 11, 2013, 11:03am UTC](https://forums.percona.com/t/trouble-after-restoring-backup-v2-1-3/2747/3 "2013-06-11T11:03:06Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![niljoshi](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/niljoshi/32/16889_2.png) [@niljoshi](https://forums.percona.com/u/niljoshi)\
**Post date:** [June 11, 2013, 11:03pm UTC](https://forums.percona.com/t/trouble-after-restoring-backup-v2-1-3/2747/4 "2013-06-11T23:03:32Z")

</div>

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