innobackupex-1.5.1 fails to take single db backup

[hi_irf]

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.

[rei125]

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.