innobackupex ignores --databases without --stream
| 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-
Related branches
- Laurynas Biveinis: Needs Fixing on 2013-03-22
- Diff: 1012 lines (+706/-130) 8 files modified
- Laurynas Biveinis: Needs Fixing on 2013-03-22
- Diff: 571 lines (+328/-31) 8 files modified
| 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 : | #1 |
| 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 : | #2 |
Linked branch contains test
| Changed in percona-xtrabackup: | |
| status: | Confirmed → Triaged |
| assignee: | Vadim Tkachenko (vadim-tk) → nobody |
| Changed in percona-xtrabackup: | |
| milestone: | 1.7.0beta1 → 1.7.0 |
| tags: | added: doc |
| tags: | removed: doc |
| tags: | added: innobackupex |
| Stewart Smith (stewart) wrote : | #3 |
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 + innobackupex ignores --databases without --stream |
| Alexey Kopytov (akopytov) wrote : | #5 |
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 : | #7 |
Bug #1274766 marked as a duplicate of this one.
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=
I'm not sure if this is the intended behavior.