# Can I restore one db from a full backup?

**URL:** <https://forums.percona.com/t/can-i-restore-one-db-from-a-full-backup/2364>\
**Category:** Percona XtraBackup\
**Created:** [April 11, 2013, 10:52am UTC](https://forums.percona.com/t/can-i-restore-one-db-from-a-full-backup/2364 "2013-04-11T10:52:12Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![eclay](https://avatars.discourse-cdn.com/v4/letter/e/e19b73/32.png) [@eclay](https://forums.percona.com/u/eclay)\
**Post date:** [April 11, 2013, 10:52am UTC](https://forums.percona.com/t/can-i-restore-one-db-from-a-full-backup/2364/1 "2013-04-11T10:52:12Z")

</div>

Hello,

I’m wondering if it’s possible to restore a single database from a prepared full backup or is my only option for this granularity to backup each db individually?

---

<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:** [April 11, 2013, 11:26am UTC](https://forums.percona.com/t/can-i-restore-one-db-from-a-full-backup/2364/2 "2013-04-11T11:26:43Z")

</div>

Do you use file-per-table? If yes, see [http://dev.mysql.com/doc/refman/5.0/en/innodb-multiple-table](http://dev.mysql.com/doc/refman/5.0/en/innodb-multiple-table) spaces.html (IMPORT TABLESPACE).

---

<div class="post-metadata">

**Author:** ![eclay](https://avatars.discourse-cdn.com/v4/letter/e/e19b73/32.png) [@eclay](https://forums.percona.com/u/eclay)\
**Post date:** [April 11, 2013, 11:33am UTC](https://forums.percona.com/t/can-i-restore-one-db-from-a-full-backup/2364/3 "2013-04-11T11:33:25Z")

</div>

Yes our MySQL servers are configured with the innodb\_file\_per\_table setting. We also support or have myisam databases on our MySQL servers. Is it possible to restore a single db from a full innobackupex?