# Innobackupex question

**URL:** <https://forums.percona.com/t/innobackupex-question/2676>\
**Category:** Percona XtraBackup\
**Created:** [May 13, 2013, 11:10am UTC](https://forums.percona.com/t/innobackupex-question/2676 "2013-05-13T11:10:04Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![spgriffinjr](https://avatars.discourse-cdn.com/v4/letter/s/53a042/32.png) [@spgriffinjr](https://forums.percona.com/u/spgriffinjr)\
**Post date:** [May 13, 2013, 11:10am UTC](https://forums.percona.com/t/innobackupex-question/2676/1 "2013-05-13T11:10:04Z")

</div>

I know its possible to backup individual schemas with innobackupex but how do you restore an individual schema without affecting the others? Do I just copy the backup directory structure and files into the working mysql directory?

---

<div class="post-metadata">

**Author:** ![gmouse](https://avatars.discourse-cdn.com/v4/letter/g/b9e5f3/32.png) [@gmouse](https://forums.percona.com/u/gmouse)\
**Post date:** [May 13, 2013, 11:50am UTC](https://forums.percona.com/t/innobackupex-question/2676/2 "2013-05-13T11:50:34Z")

</div>

For MyISAM yes, but for InnoDB see [url][Percona XtraBackup](http://www.percona.com/doc/percona-xtrabackup/innobackupex/importing_exporting_tables_ibk.html%5B/url%5D)

---

<div class="post-metadata">

**Author:** ![scott.nemes](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/scott.nemes/32/5_2.png) [@scott.nemes](https://forums.percona.com/u/scott.nemes)\
**Post date:** [May 13, 2013, 11:52am UTC](https://forums.percona.com/t/innobackupex-question/2676/3 "2013-05-13T11:52:28Z")

</div>

The process depends on if you are using MyISAM or InnoDB/XtraDB, but below are links to the manual with important information and steps on both taking the partial backup, preparing it, and restoring it:

[url][Percona XtraBackup](http://www.percona.com/doc/percona-xtrabackup/innobackupex/partial_backups_innobackupex.html%5B/url%5D)

[url][Percona XtraBackup](http://www.percona.com/doc/percona-xtrabackup/innobackupex/importing_exporting_tables_ibk.html%5B/url%5D)

---

<div class="post-metadata">

**Author:** ![spgriffinjr](https://avatars.discourse-cdn.com/v4/letter/s/53a042/32.png) [@spgriffinjr](https://forums.percona.com/u/spgriffinjr)\
**Post date:** [May 16, 2013, 7:20pm UTC](https://forums.percona.com/t/innobackupex-question/2676/4 "2013-05-16T19:20:43Z")

</div>

thanks for the info. very helpful