innobackupex ignores --databases without --stream

Reported by Ville Skyttä on 2010-04-24
This bug affects 10 people
Affects Status Importance Assigned to Milestone
Percona XtraBackup
Status tracked in 2.2
Sergei Glushchenko
Sergei Glushchenko
Sergei Glushchenko

Bug Description

If --stream is not given, innobackupex-1.5.1 from xtrabackup-1.2-14.rhel5 seems to ignore the --databases option and backs up all databases. If this cannot be fixed, the limitation should be documented in innobackupex-1.5.1's --help.

Changed in percona-xtrabackup:
importance: Undecided → Medium
assignee: nobody → Aleksandr Kuzminsky (akuzminsky)
Changed in percona-xtrabackup:
milestone: none → 1.3.1
Will Bryant (will-bryant-gmail) wrote :

Try using the --include option. --databases seems to affect for which databases the files other than .ibd are backed up, so I am using:

--databases="mysql myapp_production" --include="myapp_production\..*"

I'm not sure if this is the intended behavior.

Changed in percona-xtrabackup:
milestone: 1.3.1 → 1.6
assignee: Aleksandr Kuzminsky (akuzminsky) → Valentine Gostev (core-longbow)
Changed in percona-xtrabackup:
milestone: 1.6 → 1.7
Valentine Gostev (longbow) wrote :

Linked branch contains test

Changed in percona-xtrabackup:
status: New → Triaged
status: Triaged → Confirmed
assignee: Valentine Gostev (core-longbow) → Vadim Tkachenko (vadim-tk)
Stewart Smith (stewart) on 2011-05-20
Changed in percona-xtrabackup:
status: Confirmed → Triaged
assignee: Vadim Tkachenko (vadim-tk) → nobody
Stewart Smith (stewart) on 2011-06-02
Changed in percona-xtrabackup:
milestone: 1.7.0beta1 → 1.7.0
Stewart Smith (stewart) on 2012-02-07
tags: added: doc
tags: removed: doc
tags: added: innobackupex
Stewart Smith (stewart) wrote :

Marking as Won't fix for the old stable 1.6 release. If you need a fix for this bug in 1.6, please say so here or contact us (Percona) to arrange something.

Using XtraBackup 2.0.0 I encountered the same symptoms with --databases. I worked around this with --include as suggested in comment #1.

summary: - innobackupex ignores --databases without --stream
+ innobackupex ignores --databases
summary: - innobackupex ignores --databases
+ innobackupex ignores --databases without --stream
Alexey Kopytov (akopytov) wrote :

In fact in XtraBackup 2.0 the --databases option has no effect for InnoDB files for both local and streaming backups, i.e. all InnoDB files are always backed up. Currently, only .frm and non-InnoDB tables are limited by that option.

I suggest to introduce --databases and --databases-file xtrabackup. --databases option of innobackupex would be mapped to one of them.

Alexey Kopytov (akopytov) wrote :

Bug #1274766 marked as a duplicate of this one.

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Duplicates of this bug

Other bug subscribers

Related questions