innobackupex --databases Does not Work as Expected

Bug #1274766 reported by Jervin R
10
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://www.percona.com/doc/percona-xtrabackup/2.1/innobackupex/innobackupex_option_reference.html

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.

Revision history for this message
Jervin R (revin) wrote :
Download full text (6.3 KiB)

[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:
http://www.percona.com/xb/p

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=xtrabackup' (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
innobackupex: Waiting for ibbackup (pid=19414) to suspend
innobackupex: Suspend file '/ssd/msb/msb_5_5_340/bkp/local/2014-01-30_19-04-57/xtrabackup_suspended_2'

xtrabackup_55 version 2.1.7 for Percona Server 5.5.35 Linux (x86_64) (revision id: 721)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /ssd/msb/msb_5_5_340/data
xtrabackup: using the following InnoDB configuration:
xtrabackup: innodb_data_home_dir = ./
xtrabackup: innodb_data_file_path = ibdata1:10M:autoextend
xtrabackup: innodb_log_group_home_dir = ./
xtrabackup: innodb_log_files_in_group = 2
xtrabackup: innodb_log_file_size = 5242880
>> log scanned up to (11822949064)
140130 19:04:57 InnoDB: Warning: allocated tablespace 10, old maximum was 9
[01] Copying ./ibdata1 to /ssd/msb/msb_5_5_340/bkp/local/2014-01-30_19-04-57/ibdata1
[01] ...done
[01] Copying ./test/sbtest1.ibd to /ssd/msb/msb_5_5_340/bkp/local/2014-01-30_19-04-57/test/sbtest1.ibd
>> log scanned up to (11822949064)
>> log scanned up to (11822949064)
[01] ...done
[01] Copying ./test/t.ibd to /ssd/msb/msb_5_5_340/bkp/local/2014-01-30_19-04-57/test/t.ibd
[01] ...done
[01] Copying ./test/t2.ibd to /ssd/msb/msb_5_5_340/bkp/local/2014-01-30_19-04-57/test/t2.ibd
[01] ...done
[01] Copying ./test/t1.ibd to /ssd/msb/msb_5_5_340/bkp/local/2014-01-30_19-04-57/test/t1.ibd
[01] ...done
[01] Copying ./test/trx.ibd to /ssd/msb/msb_5_5_340/bkp/local/2014-01-30_19-04-57/test/trx.ibd
[01] ...done
[01] Copying ./common_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
[01] ...done
[01] Copying ./common_schema/_global_script_report_data.ibd to /ssd/msb/msb_5_5_340/bkp/local...

Read more...

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

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.