# need informations fo restoring data

**URL:** <https://forums.percona.com/t/need-informations-fo-restoring-data/2319>\
**Category:** Percona XtraBackup\
**Created:** [December 20, 2012, 4:40am UTC](https://forums.percona.com/t/need-informations-fo-restoring-data/2319 "2012-12-20T04:40:33Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![KoHead](https://avatars.discourse-cdn.com/v4/letter/k/e36b37/32.png) [@KoHead](https://forums.percona.com/u/KoHead)\
**Post date:** [December 20, 2012, 4:40am UTC](https://forums.percona.com/t/need-informations-fo-restoring-data/2319/1 "2012-12-20T04:40:33Z")

</div>

Hi all,

I have some questions about the restore process of data with innobackup and xtrabackup.

The restart of mysql server is mandatory ?

This step is also mandatory ?

sudo mv /var/lib/mysql /var/lib/mysql-old$ sudo cp -R /var/backups/mysql/2011-03-19\_19-08-58 /var/lib/mysql$ sudo chown -R mysql:mysql /var/lib/mysql

I must necesseraly destroy the datadir ? entirely ?

Thank you

Dam

---

<div class="post-metadata">

**Author:** ![ernesto\_vargas](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ernesto_vargas/32/768_2.png) [@ernesto\_vargas](https://forums.percona.com/u/ernesto_vargas)\
**Post date:** [December 20, 2012, 10:53am UTC](https://forums.percona.com/t/need-informations-fo-restoring-data/2319/2 "2012-12-20T10:53:57Z")

</div>

You MUST stop mysql before restoring you backup.

Do the 3 steps you mention before. Then run “innobackupex --apply-log --use-memory=2G /var/lib/mysql”

Then restart mysql.

---

<div class="post-metadata">

**Author:** ![KoHead](https://avatars.discourse-cdn.com/v4/letter/k/e36b37/32.png) [@KoHead](https://forums.percona.com/u/KoHead)\
**Post date:** [December 20, 2012, 10:55am UTC](https://forums.percona.com/t/need-informations-fo-restoring-data/2319/3 "2012-12-20T10:55:21Z")

</div>

ok.

Thank you for answer !