innobackupex ignores --databases without --stream

Reported by Ville Skyttä on 2010-04-24
52
This bug affects 10 people
Affects Status Importance Assigned to Milestone
Percona XtraBackup
Status tracked in 2.2
1.6
Medium
Unassigned
2.0
Medium
Sergei Glushchenko
2.1
Medium
Sergei Glushchenko
2.2
Medium
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