# Percona innobackupex restoring problem

**URL:** <https://forums.percona.com/t/percona-innobackupex-restoring-problem/3601>\
**Category:** Percona XtraBackup\
**Created:** [July 8, 2014, 7:00am UTC](https://forums.percona.com/t/percona-innobackupex-restoring-problem/3601 "2014-07-08T07:00:22Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![kannan2410](https://avatars.discourse-cdn.com/v4/letter/k/13edae/32.png) [@kannan2410](https://forums.percona.com/u/kannan2410)\
**Post date:** [July 8, 2014, 7:00am UTC](https://forums.percona.com/t/percona-innobackupex-restoring-problem/3601/1 "2014-07-08T07:00:22Z")

</div>

Hi All,  
I have a problem while restoring my full backup using innobackupex, below are the steps which i am doing.

1. innobackupex --user=root --password=test123 /data/backup/innobackupex/Full/

2. innobackupex --apply-log --redo-only /data/backup/innobackupex/Full/2014-07-03\_14-39-24/

3. /etc/init.d/mysql stop

removing files from mysql data dir…

1. rm -rf /data/mysql/data/\*

restoring backup to datadir (/data/mysql/data)

1. innobackupex --copy-back /data/backup/innobackupex/Full/2014-07-03\_14-39-24/

2. chown -R mysql:mysql /data/mysql/data/

3. /etc/init.d/mysql start

Upto this everything is perfect. I didn’t get any error. successfully started mysql…

but no data available on my database…The error is below while checking the tables…

mysql\> select \* from db.User1;  
ERROR 1146 (42S02): Table ‘db.User1’ doesn’t exist

Can anyone help me here…?  
Thanks in advance…

---

<div class="post-metadata">

**Author:** ![psong](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/psong/32/16894_2.png) [@psong](https://forums.percona.com/u/psong)\
**Post date:** [July 10, 2014, 3:24am UTC](https://forums.percona.com/t/percona-innobackupex-restoring-problem/3601/2 "2014-07-10T03:24:25Z")

</div>

What do “ls -l /data/mysql/data” and “ls -l /data/mysql/data/db” show? Btw, when you prepare a full backup, it is better to leave out --redo-only and allow the prepare step to rollback uncommitted transactions. And so it would save time to start up the server on the prepared data.

---

<div class="post-metadata">

**Author:** ![kannan2410](https://avatars.discourse-cdn.com/v4/letter/k/13edae/32.png) [@kannan2410](https://forums.percona.com/u/kannan2410)\
**Post date:** [July 14, 2014, 12:51am UTC](https://forums.percona.com/t/percona-innobackupex-restoring-problem/3601/3 "2014-07-14T00:51:22Z")

</div>

Hi psong,

It works fine after leaving (–redo-only) while preparing full backup…

Thanks a lot. 🙂