# innobackupex partial backup copies all idb files **URL:** \ **Category:** Percona XtraBackup\ **Created:** [June 1, 2012, 10:30am UTC](https://forums.percona.com/t/innobackupex-partial-backup-copies-all-idb-files/2249 "2012-06-01T10:30:24Z")\ **Posts on this page:** 1\ **Page:** 1
**Author:** ![emeitner](https://avatars.discourse-cdn.com/v4/letter/e/b5a626/32.png) [@emeitner](https://forums.percona.com/u/emeitner)\ **Post date:** [June 1, 2012, 10:30am UTC](https://forums.percona.com/t/innobackupex-partial-backup-copies-all-idb-files/2249/1 "2012-06-01T10:30:24Z")
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 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!