innobackupex --databases Does not Work as Expected
Bug #1274766 reported by
Jervin R
This bug report is a duplicate of:
Bug #569387: innobackupex ignores --databases without --stream.
Edit
Remove
This bug affects 2 people
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona XtraBackup moved to https://jira.percona.com/projects/PXB |
New
|
Undecided
|
Unassigned |
Bug Description
According to the documentation, specifying a list of --databases to backup only backs up those database.
http://
If I do innobackupex --databases=test it should only backup the test database, however it also copies other tables - see following log. I'd have to add --include for it to work or use tables-list instead. This should be fixed in documentation if intended that way.
To post a comment you must log in.
[revin@forge msb_5_5_340]$ innobackupex --defaults- file="/ ssd/msb/ msb_5_5_ 340/my. sandbox. cnf" --databases="test" /ssd/msb/ msb_5_5_ 340/bkp/ local/
InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona LLC and/or its affiliates 2009-2013. All Rights Reserved.
This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.
Get the latest version of Percona XtraBackup, documentation, and help resources: www.percona. com/xb/ p
http://
140130 19:04:57 innobackupex: Connecting to MySQL server with DSN 'dbi:mysql: ;mysql_ read_default_ file=/ssd/ msb/msb_ 5_5_340/ my.sandbox. cnf;mysql_ read_default_ group=xtrabacku p' (using password: NO).
140130 19:04:57 innobackupex: Connected to MySQL server
140130 19:04:57 innobackupex: Executing a version check against the server...
140130 19:04:57 innobackupex: Done.
IMPORTANT: Please check that the backup run completes successfully.
At the end of a successful backup run innobackupex
prints "completed OK!".
innobackupex: Using mysql server version 5.5.34-rel32.0-log
innobackupex: Created backup directory /ssd/msb/ msb_5_5_ 340/bkp/ local/2014- 01-30_19- 04-57
140130 19:04:57 innobackupex: Starting ibbackup with command: xtrabackup_55 --defaults- file="/ ssd/msb/ msb_5_5_ 340/my. sandbox. cnf" --defaults- group=" mysqld" --backup --suspend-at-end --target- dir=/ssd/ msb/msb_ 5_5_340/ bkp/local/ 2014-01- 30_19-04- 57 --tmpdir= /ssd/msb/ msb_5_5_ 340/tmp msb_5_5_ 340/bkp/ local/2014- 01-30_19- 04-57/xtrabacku p_suspended_ 2'
innobackupex: Waiting for ibbackup (pid=19414) to suspend
innobackupex: Suspend file '/ssd/msb/
xtrabackup_55 version 2.1.7 for Percona Server 5.5.35 Linux (x86_64) (revision id: 721) msb_5_5_ 340/data data_home_ dir = ./ data_file_ path = ibdata1: 10M:autoextend log_group_ home_dir = ./ log_files_ in_group = 2 log_file_ size = 5242880 msb_5_5_ 340/bkp/ local/2014- 01-30_19- 04-57/ibdata1 msb_5_5_ 340/bkp/ local/2014- 01-30_19- 04-57/test/ sbtest1. ibd msb_5_5_ 340/bkp/ local/2014- 01-30_19- 04-57/test/ t.ibd msb_5_5_ 340/bkp/ local/2014- 01-30_19- 04-57/test/ t2.ibd msb_5_5_ 340/bkp/ local/2014- 01-30_19- 04-57/test/ t1.ibd msb_5_5_ 340/bkp/ local/2014- 01-30_19- 04-57/test/ trx.ibd schema/ _global_ qs_variables. ibd to /ssd/msb/ msb_5_5_ 340/bkp/ local/2014- 01-30_19- 04-57/common_ schema/ _global_ qs_variables. ibd schema/ _global_ script_ report_ data.ibd to /ssd/msb/ msb_5_5_ 340/bkp/ local.. .
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /ssd/msb/
xtrabackup: using the following InnoDB configuration:
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
>> log scanned up to (11822949064)
140130 19:04:57 InnoDB: Warning: allocated tablespace 10, old maximum was 9
[01] Copying ./ibdata1 to /ssd/msb/
[01] ...done
[01] Copying ./test/sbtest1.ibd to /ssd/msb/
>> log scanned up to (11822949064)
>> log scanned up to (11822949064)
[01] ...done
[01] Copying ./test/t.ibd to /ssd/msb/
[01] ...done
[01] Copying ./test/t2.ibd to /ssd/msb/
[01] ...done
[01] Copying ./test/t1.ibd to /ssd/msb/
[01] ...done
[01] Copying ./test/trx.ibd to /ssd/msb/
[01] ...done
[01] Copying ./common_
[01] ...done
[01] Copying ./common_