# restore one table from xtrabackup's full backup

**URL:** <https://forums.percona.com/t/restore-one-table-from-xtrabackups-full-backup/2169>\
**Category:** Percona XtraBackup\
**Created:** [September 27, 2011, 3:54pm UTC](https://forums.percona.com/t/restore-one-table-from-xtrabackups-full-backup/2169 "2011-09-27T15:54:28Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![xudba](https://avatars.discourse-cdn.com/v4/letter/x/a587f6/32.png) [@xudba](https://forums.percona.com/u/xudba)\
**Post date:** [September 27, 2011, 3:54pm UTC](https://forums.percona.com/t/restore-one-table-from-xtrabackups-full-backup/2169/1 "2011-09-27T15:54:28Z")

</div>

Is there anyway to restore only one table or schema from xtrabackup’s full backup?

It seems that in order to restore one table only, I need to restore the whole database and extract the table out after that

---

<div class="post-metadata">

**Author:** ![xudba](https://avatars.discourse-cdn.com/v4/letter/x/a587f6/32.png) [@xudba](https://forums.percona.com/u/xudba)\
**Post date:** [September 29, 2011, 5:47pm UTC](https://forums.percona.com/t/restore-one-table-from-xtrabackups-full-backup/2169/2 "2011-09-29T17:47:52Z")

</div>

found the solution.

---

<div class="post-metadata">

**Author:** ![nvaslav](https://avatars.discourse-cdn.com/v4/letter/n/a5b964/32.png) [@nvaslav](https://forums.percona.com/u/nvaslav)\
**Post date:** [January 14, 2013, 10:14am UTC](https://forums.percona.com/t/restore-one-table-from-xtrabackups-full-backup/2169/3 "2013-01-14T10:14:48Z")

</div>

Can you please let me know your solution to restore single schema with xtrabackup

---

<div class="post-metadata">

**Author:** ![Andre1976](https://avatars.discourse-cdn.com/v4/letter/a/a587f6/32.png) [@Andre1976](https://forums.percona.com/u/Andre1976)\
**Post date:** [April 5, 2023, 11:51am UTC](https://forums.percona.com/t/restore-one-table-from-xtrabackups-full-backup/2169/4 "2023-04-05T11:51:20Z")

</div>

Hello @xudba

So , Can We restore one single table from Full XTraback with another name ?

For example, If our table is called as Table1 , Can We restore as Table1\_restore ?

Thanks in advance  
Andre