Announcement

Announcement Module
Collapse
No announcement yet.

innobackupex-1.5.1 fails to take single db backup

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • innobackupex-1.5.1 fails to take single db backup

    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.

  • #2
    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.

    Comment

    Working...
    X