# innobackupex-1.5.1 fails to take single db backup

**URL:** <https://forums.percona.com/t/innobackupex-1-5-1-fails-to-take-single-db-backup/2170>\
**Category:** Percona XtraBackup\
**Created:** [September 30, 2011, 1:28am UTC](https://forums.percona.com/t/innobackupex-1-5-1-fails-to-take-single-db-backup/2170 "2011-09-30T01:28:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![hi\_irf](https://avatars.discourse-cdn.com/v4/letter/h/82dd89/32.png) [@hi\_irf](https://forums.percona.com/u/hi_irf)\
**Post date:** [September 30, 2011, 1:28am UTC](https://forums.percona.com/t/innobackupex-1-5-1-fails-to-take-single-db-backup/2170/1 "2011-09-30T01:28:00Z")

</div>

Hello,

I need to take single database full backup & incremental backup only. But it takes backup of all datatabases.

Till now i tried databases=dbname --tables=db\_name.\*

ERROR: xtrabackup: cannot open dbname.\*

Following two commands takes all database backup. But i need only one database backup.

$$ perl /usr/local/xtrabackup-1.5/bin/innobackupex-1.5.1 --databases=dbname --include=dbname[^a-zA-Z0-9].[a-zA-Z0-9]\* --user=XXXXX --password=XXXXX --socket=/var/lib/mysql/mysql.sock --defaults-file=“/etc/my.cnf” /backup/innobackup/

$$ perl /usr/local/xtrabackup-1.5/bin/innobackupex-1.5.1 --databases=dbname --include=dbname[^a-zA-Z0-9].[a-zA-Z0-9]\* --user=XXXXX --password=XXXXX --socket=/var/lib/mysql/mysql.sock --defaults-file=“/etc/my.cnf” /backup/innobackup/

Please let me know how to take only one database full backup and incremental backups.  
Also does it possible to restore only one database from all database backup destincation ?

Thank you.

---

<div class="post-metadata">

**Author:** ![rei125](https://avatars.discourse-cdn.com/v4/letter/r/3da27b/32.png) [@rei125](https://forums.percona.com/u/rei125)\
**Post date:** [June 6, 2012, 8:29pm UTC](https://forums.percona.com/t/innobackupex-1-5-1-fails-to-take-single-db-backup/2170/2 "2012-06-06T20:29:23Z")

</div>

hi,

i come upon this question when i’m trying out the single db backup.  
have you found a solution to this?  
i’m facing exactly the same problem.

thank you.