# Backup one database with xtrabackup

**URL:** <https://forums.percona.com/t/backup-one-database-with-xtrabackup/3058>\
**Category:** Percona XtraBackup\
**Created:** [November 5, 2013, 11:49am UTC](https://forums.percona.com/t/backup-one-database-with-xtrabackup/3058 "2013-11-05T11:49:24Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![AdriannaXTS](https://avatars.discourse-cdn.com/v4/letter/a/b487fb/32.png) [@AdriannaXTS](https://forums.percona.com/u/AdriannaXTS)\
**Post date:** [November 5, 2013, 11:49am UTC](https://forums.percona.com/t/backup-one-database-with-xtrabackup/3058/1 "2013-11-05T11:49:24Z")

</div>

Hello ;

On my cluster PXC, I have several databases. I want to backup only one of them. But the instruction I find out in the manual don’t show how to do it .

I juste find how to backup all the databases, or how to do an incremental backup. Does someone know some particular command?

Thanks in advance.

---

<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:** [November 5, 2013, 10:23pm UTC](https://forums.percona.com/t/backup-one-database-with-xtrabackup/3058/2 "2013-11-05T22:23:26Z")

</div>

Percona Xtrabackup do supports [Partial Backups](http://www.percona.com/doc/percona-xtrabackup/2.1/innobackupex/partial_backups_innobackupex.html). i.e. backup particular database/tables.  
You need to use --include, --tables-file or --databases option to backup selected database/tables.

e.g.

$ mysql --skip-column-names -e “SELECT CONCAT(table\_schema,‘.’,table\_name) FROM information\_schema.tables WHERE table\_schema = ‘mydb’;” \> tables.txt  
$ innobackupex --tables-file=tables.txt /path/to/backupdir/

---

<div class="post-metadata">

**Author:** ![ashokkumar2003](https://avatars.discourse-cdn.com/v4/letter/a/a698b9/32.png) [@ashokkumar2003](https://forums.percona.com/u/ashokkumar2003)\
**Post date:** [November 6, 2013, 12:32am UTC](https://forums.percona.com/t/backup-one-database-with-xtrabackup/3058/3 "2013-11-06T00:32:02Z")

</div>

You can also use mysqldump command as like below mentioned for taken a single mysql database backup.

mysqldump -uabc -pabc dbname \> dbname.sql

if you need single table then

mysqldump -uabc -pabc dbname tablenae \> table.sql