Innobackupex doesn't add file-per-table setting for table-independent backups
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| Percona XtraBackup moved to https://jira.percona.com/projects/PXB |
Fix Released
|
Medium
|
Alexey Kopytov | ||
| 2.0 |
Fix Released
|
Medium
|
Alexey Kopytov | ||
| 2.1 |
Fix Released
|
Medium
|
Alexey Kopytov | ||
Bug Description
When using the --export option for innobackupex to create table-independent InnoDB backups the auto-generated backup-my.cnf file doesn't contain the option "innodb-
Version info:
$ innobackupex --version
InnoDB Backup Utility v1.5.1-xtrabackup;
$ xtrabackup --version
xtrabackup version 1.6.4 for Percona Server 5.1.59 unknown-linux-gnu (x86_64) (revision id: 314)
$ mysql --version
mysql Ver 14.14 Distrib 5.5.14, for Linux (x86_64) using readline 5.1
$ uname -a
Linux ***** 2.6.18-194.32.1.el5 #1 SMP Mon Dec 20 10:52:42 EST 2010 x86_64 x86_64 x86_64 GNU/Linux
$ cat /etc/redhat-release
Red Hat Enterprise Linux Server release 5.6 (Tikanga)
Related branches
- Sergei Glushchenko (community): Approve (g2)
-
Diff: 125 lines (+68/-13)4 files modifieddoc/source/xtrabackup_bin/exporting_importing_tables.rst (+2/-2)
src/xtrabackup.cc (+5/-3)
test/t/bug930062.sh (+61/-0)
test/t/xb_export.sh (+0/-8)
- Sergei Glushchenko (community): Approve (g2)
-
Diff: 125 lines (+68/-13)4 files modifieddoc/source/xtrabackup_bin/exporting_importing_tables.rst (+2/-2)
src/xtrabackup.cc (+5/-3)
test/t/bug930062.sh (+61/-0)
test/t/xb_export.sh (+0/-8)
| Matt (whereswardy) wrote | #1 |
| Changed in percona-xtrabackup: | |
| importance: | Undecided → High |
| Changed in percona-xtrabackup: | |
| importance: | High → Medium |
| Shahriyar Rzayev (rzayev-sehriyar) wrote | #3 |
I've noticed that xtrabackup itself has a command line option --file-per-table to tell it that it's dealing with this option during the backup, but there's no way to set this if you're using innobackupex. Perhaps innobackupex should always set this option with xtrabackup if using --export?