# ~ in table names does not work in xtrabackup...

**URL:** <https://forums.percona.com/t/in-table-names-does-not-work-in-xtrabackup/4795>\
**Category:** Percona XtraBackup\
**Created:** [March 20, 2016, 4:29pm UTC](https://forums.percona.com/t/in-table-names-does-not-work-in-xtrabackup/4795 "2016-03-20T16:29:33Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![saumil](https://avatars.discourse-cdn.com/v4/letter/s/47e85d/32.png) [@saumil](https://forums.percona.com/u/saumil)\
**Post date:** [March 20, 2016, 4:29pm UTC](https://forums.percona.com/t/in-table-names-does-not-work-in-xtrabackup/4795/1 "2016-03-20T16:29:33Z")

</div>

Hi, I am using Xtrabackup 2.4.1 with Mysql 5.5 to backup individual tables. The list of tables to backup are in a text file, where each table name ( in schemaname.tablename format ) is in a single row.  
The problem is that many of our tables are called ~jobs, and xtrabackup gives me error when it encounters this type of name (e.g. xtrabackup: name `ae.~jobs` is not valid). Is there a way to make these tables work with xtrabackup ?  
Thanks…

---

<div class="post-metadata">

**Author:** ![mirfan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mirfan/32/16890_2.png) [@mirfan](https://forums.percona.com/u/mirfan)\
**Post date:** [March 25, 2016, 3:47pm UTC](https://forums.percona.com/t/in-table-names-does-not-work-in-xtrabackup/4795/2 "2016-03-25T15:47:34Z")

</div>

Backing up individual database tables or selected database or tables known as Partial Backup. You need to mention each database.tablename in new line and you can use --tables-file option to backup something like below: [LEFT]  
[COLOR=#002D7A !important]  
[LEFT]  
One of my blogpost describes this method [url][https://www.percona.com/blog/2014/12/09/mysql-5-6-transportable-tablespaces-best-practices/[/url]](https://www.percona.com/blog/2014/12/09/mysql-5-6-transportable-tablespaces-best-practices/%5B/url%5D)  
You can also refer to Xtrabackup Partial Backup documentation for details here [url][Percona XtraBackup](https://www.percona.com/doc/percona-xtrabackup/2.3/innobackupex/partial_backups_innobackupex.html%5B/url%5D)

---

<div class="post-metadata">

**Author:** ![mirfan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mirfan/32/16890_2.png) [@mirfan](https://forums.percona.com/u/mirfan)\
**Post date:** [March 25, 2016, 3:48pm UTC](https://forums.percona.com/t/in-table-names-does-not-work-in-xtrabackup/4795/3 "2016-03-25T15:48:51Z")

</div>

```auto
[COLOR=#002D7A !important]
```

---

<div class="post-metadata">

**Author:** ![mirfan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mirfan/32/16890_2.png) [@mirfan](https://forums.percona.com/u/mirfan)\
**Post date:** [March 25, 2016, 3:49pm UTC](https://forums.percona.com/t/in-table-names-does-not-work-in-xtrabackup/4795/4 "2016-03-25T15:49:39Z")

</div>

```auto
innobackupex --no-timestamp --tables-file=/root/tables_to_backup.txt /root/partial_backup/ > /root/xtrabackup.log 2>&1

```