Not the answer you need?
Register and ask your own question!

innobackupex-1.5.1 fails to take single db backup

hi_irfhi_irf ContributorCurrent User Role Beginner
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.

Comments

  • rei125rei125 Entrant Current User Role Beginner
    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.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.