# Using option tables-file

**URL:** <https://forums.percona.com/t/using-option-tables-file/4927>\
**Category:** Percona XtraBackup\
**Created:** [June 14, 2016, 9:18am UTC](https://forums.percona.com/t/using-option-tables-file/4927 "2016-06-14T09:18:43Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ony](https://avatars.discourse-cdn.com/v4/letter/o/ce7236/32.png) [@ony](https://forums.percona.com/u/ony)\
**Post date:** [June 14, 2016, 9:18am UTC](https://forums.percona.com/t/using-option-tables-file/4927/1 "2016-06-14T09:18:43Z")

</div>

Hello,

I would like to use the option this backup :  
$ echo “mydatabase.mytable” \> /tmp/tables.txt  
$ innobackupex --tables-file=/tmp/tables.txt /path/to/backup

The backup is OK and completed, but I couldn’t see the paragraph to precise how to restore the backup with this option.  
So, someone could tell me how to do this?

Thank you for your reply 🙂

---

<div class="post-metadata">

**Author:** ![ony](https://avatars.discourse-cdn.com/v4/letter/o/ce7236/32.png) [@ony](https://forums.percona.com/u/ony)\
**Post date:** [June 15, 2016, 7:36am UTC](https://forums.percona.com/t/using-option-tables-file/4927/2 "2016-06-15T07:36:40Z")

</div>

Hello!  
I found this topic [url][Percona XtraBackup](https://www.percona.com/doc/percona-xtrabackup/2.3/innobackupex/partial_backups_innobackupex.html%5B/url%5D)  
But Is what I am therefore obliged to create all the tables like this? My goal is to save all other tables except one. This one table is saved by partition because it is too large to be backup in full. Will you might give me another solution or is it that I recreate the other tables when I restore and follow this manipulation [url][Percona XtraBackup](https://www.percona.com/doc/percona-xtrabackup/2.3/innobackupex/restoring_individual_tables_ibk.html%5B/url%5D) ?

---

<div class="post-metadata">

**Author:** ![jrivera](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/jrivera/32/13_2.png) [@jrivera](https://forums.percona.com/u/jrivera)\
**Post date:** [June 15, 2016, 8:19am UTC](https://forums.percona.com/t/using-option-tables-file/4927/3 "2016-06-15T08:19:20Z")

</div>

[url][Percona XtraBackup](https://www.percona.com/doc/percona-xtrabackup/2.3/howtos/recipes_ibkx_partition.html%5B/url%5D)

Start from Preparing the Backup up to Restoring the Backup.

---

<div class="post-metadata">

**Author:** ![ony](https://avatars.discourse-cdn.com/v4/letter/o/ce7236/32.png) [@ony](https://forums.percona.com/u/ony)\
**Post date:** [June 15, 2016, 8:48am UTC](https://forums.percona.com/t/using-option-tables-file/4927/4 "2016-06-15T08:48:13Z")

</div>

Hello,

I have already prepared the backup but to restore I had hoped another solution to avoid recreating all the tables in the tables.txt file like this :  
mysql\> CREATE TABLE `name_p4` ( `id` int(11) NOT NULL AUTO\_INCREMENT, `name` text NOT NULL, `imdb_index` varchar(12) DEFAULT NULL, `imdb_id` int(11) DEFAULT NULL, `name_pcode_cf` varchar(5) DEFAULT NULL, `name_pcode_nf` varchar(5) DEFAULT NULL, `surname_pcode` varchar(5) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO\_INCREMENT=2812744 DEFAULT CHARSET=utf8 Because I have many tables!

Regards,