# Restoring  A Specific Table Using XtraBackup

**URL:** <https://forums.percona.com/t/restoring-a-specific-table-using-xtrabackup/4720>\
**Category:** Percona XtraBackup\
**Created:** [February 14, 2016, 6:32am UTC](https://forums.percona.com/t/restoring-a-specific-table-using-xtrabackup/4720 "2016-02-14T06:32:11Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![avrahamk](https://avatars.discourse-cdn.com/v4/letter/a/edb3f5/32.png) [@avrahamk](https://forums.percona.com/u/avrahamk)\
**Post date:** [February 14, 2016, 6:32am UTC](https://forums.percona.com/t/restoring-a-specific-table-using-xtrabackup/4720/1 "2016-02-14T06:32:11Z")

</div>

We’re currently backing and up and restoring using the --export option in order to allow specific tables restore once a full backup and its incremental backups has been prepared in the following way:

1. first with the --apply-log --redo-only arguments
2. then applying incremental backups using --apply-log --incremental-dir=
3. and eventually --apply-log --export

This generates a restored DB directory structure in which every table has its own set of files,  
Which can then be selectively copied and used to restore a specific table on another DB.

Thing is - this is taking exactly the same it as if it would have taken to simply prepare the DB and open it temporarily so this table can be export/imported onwards to the other DB.

Is there any way of specifically selecting a Table(s) to be restored without having to restore the entire backup set?

Thanks,  
Avraham K