Not the answer you need?
Register and ask your own question!

innobackupex partial backup copies all idb files

emeitneremeitner EntrantInactive User Role Beginner
During a partial backup idb files from unselected databases are being copied. Only those InnoDB tables that were created after we changed the server to innodb_file_per_table are being copied - those that are not in the shared tablespace.

I run: /usr/bin/innobackupex --databases "rt mysql zzzz_delete_me_zzz" --no-timestamp --use-memory=1G junk2

The resulting backup has the following directory structure:

junk2/├── backup-my.cnf├── drupal_eggiebuzz_dev│   ├── g2_AccessMap.ibd.. SNIP ..│   └── gallery2_WebDavLockMap.ibd├── emeitner│   └── Users.ibd├── ibdata1├── mysql│   ├── columns_priv.frm│   ├── columns_priv.MYD│   ├── columns_priv.MYI.. SNIP ..│   ├── user.frm│   ├── user_info.frm│   ├── user_info.MYD│   ├── user_info.MYI│   ├── user.MYD│   └── user.MYI├── rt│   ├── db.opt│   ├── group_rights_map.frm│   ├── group_rights_map.MYD│   ├── group_rights_map.MYI.. SNIP ..│   ├── rights_sets.frm│   ├── rights_sets.MYD│   └── rights_sets.MYI├── xtrabackup_binary├── xtrabackup_binlog_info├── xtrabackup_checkpoints├── xtrabackup_logfile└── zzzz_delete_me_zzz ├── db.opt ├── zzzzz.frm └── zzzzz.ibd</pre>

Notice that the databases I selected for backup contain the frm files as they should. The other unwanted databases,"emeitner" and "drupal_eggiebuzz_dev", only contain the idb files.


Server is Debian Squeeze
mysql-server-5.1 package version 5.1.61-0+squeeze1
percona-xtrabackup package version 2.0.0-417.squeeze.

Any ideas?

Output of the above command:


InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oyand Percona Inc 2009-2012. All Rights Reserved.This software is published underthe GNU GENERAL PUBLIC LICENSE Version 2, June 1991.120601 10:31:39 innobackupex: Starting mysql with options: --unbuffered --120601 10:31:39 innobackupex: Connected to database with mysql child process (pid=424)120601 10:31:45 innobackupex: Connection to database server closedIMPORTANT: Please check that the backup run completes successfully. At the end of a successful backup run innobackupex prints "completed OK!".innobackupex: Using mysql Ver 14.14 Distrib 5.1.61, for debian-linux-gnu (x86_64) using readline 6.1innobackupex: Using mysql server version Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.innobackupex: Created backup directory /var/staged-backups/mysql/staged/test/junk2120601 10:31:45 innobackupex: Starting mysql with options: --unbuffered --120601 10:31:45 innobackupex: Connected to database with mysql child process (pid=513)120601 10:31:47 innobackupex: Connection to database server closed120601 10:31:47 innobackupex: Starting ibbackup with command: xtrabackup_51 --backup --suspend-at-end --target-dir=/var/staged-backups/mysql/staged/test/junk2 --use-memory=1Ginnobackupex: Waiting for ibbackup (pid=539) to suspendinnobackupex: Suspend file '/var/staged-backups/mysql/staged/test/junk2/xtrabackup_suspended'xtrabackup_51 version 2.0.0 for MySQL server 5.1.59 unknown-linux-gnu (x86_64) (revision id: undefined)xtrabackup: uses posix_fadvise().xtrabackup: cd to /var/lib/mysqlxtrabackup: Target instance is assumed as followings.xtrabackup: innodb_data_home_dir = xtrabackup: innodb_data_file_path = ibdata1:100M:autoextendxtrabackup: innodb_log_group_home_dir = ./xtrabackup: innodb_log_files_in_group = 2xtrabackup: innodb_log_file_size = 1073741824>> log scanned up to (0 2162200892)[01] Copying ibdata1 to /var/staged-backups/mysql/staged/test/junk2/ibdata1>> log scanned up to (0 2162200892)>> log scanned up to (0 2162200892)[01] ...done[01] Copying ./zzzz_delete_me_zzz/zzzzz.ibd to /var/staged-backups/mysql/staged/test/junk2/./zzzz_delete_me_zzz/zzzzz.ibd[01] ...done[01] Copying ./drupal_eggiebuzz_dev/g2_TkOperatnMimeTypeMap.ibd to /var/staged-backups/mysql/staged/test/junk2/./drupal_eggiebuzz_dev/g2_TkOperatnMimeTypeMap.ibd[01] ...done.. SNIP ..[01] Copying ./drupal_eggiebuzz_dev/g2_MovieItem.ibd to /var/staged-backups/mysql/staged/test/junk2/./drupal_eggiebuzz_dev/g2_MovieItem.ibd[01] ...done[01] Copying ./emeitner/Users.ibd to /var/staged-backups/mysql/staged/test/junk2/./emeitner/Users.ibd[01] ...done120601 10:32:01 innobackupex: Continuing after ibbackup has suspended120601 10:32:01 innobackupex: Starting mysql with options: --unbuffered --120601 10:32:01 innobackupex: Connected to database with mysql child process (pid=1196)>> log scanned up to (0 2162200892)120601 10:32:03 innobackupex: Starting to lock all tables...>> log scanned up to (0 2162200892)>> log scanned up to (0 2162200892)120601 10:32:13 innobackupex: All tables locked and flushed to disk120601 10:32:13 innobackupex: Starting to backup .frm, .MRG, .MYD, .MYI,innobackupex: .TRG, .TRN, .ARM, .ARZ, .CSM, .CSV and .opt files ininnobackupex: subdirectories of '/var/lib/mysql'innobackupex: Backing up file '/var/lib/mysql/zzzz_delete_me_zzz/db.opt'innobackupex: Backing up file '/var/lib/mysql/zzzz_delete_me_zzz/zzzzz.frm'innobackupex: Backing up files '/var/lib/mysql/rt/*.{frm,MYD,MYI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (10 files)innobackupex: Backing up files '/var/lib/mysql/mysql/*.{frm,MYD,MYI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (72 files)120601 10:32:13 innobackupex: Finished backing up .frm, .MRG, .MYD, .MYI, .TRG, .TRN, .ARM, .ARZ, .CSV, .CSM and .opt filesinnobackupex: Resuming ibbackupxtrabackup: The latest check point (for incremental): '0:2162200892'xtrabackup: Stopping log copying thread..>> log scanned up to (0 2162200892)xtrabackup: Transaction log of lsn (0 2162200892) to (0 2162200892) was copied.120601 10:32:15 innobackupex: All tables unlocked120601 10:32:15 innobackupex: Connection to database server closedinnobackupex: Backup created in directory '/var/staged-backups/mysql/staged/test/junk2'innobackupex: MySQL binlog position: filename '', position 120601 10:32:15 innobackupex: completed OK!</pre>
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.