title: Does xtrabackup(innobackupex) works correctly with innodb_file_per_table (Barracuda)?
body: <h1>Trying backup with Percona Xtrabackup</h1>
  
  <p>I tried to use Percona Xtrabackup to backup all InnoDB databases in my MySQL data directory.</p>
  
  <p>After executing the following command:</p>
  
  <pre><code>innobackupex --host=127.0.0.1 --port=3306 --user root --password PASSWD --defaults-file=/path/to/my.cnf --slave-info  /backup/xtrabackup
  </code></pre>
  
  <p>The process seemed to be completed with the following log:</p>
  
  <pre><code>InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
  and Percona LLC and/or its affiliates 2009-2013.  All Rights Reserved.
  ...
  innobackupex: Using mysql server version 5.6.12
  
  innobackupex: Created backup directory /nobackup/xtrabackup/2014-02-24_00-04-21
  ...
  [01] Copying /var/lib/mysql/ibdata1 to /nobackup/xtrabackup/2014-02-24_00-04-21/ibdata1
  &gt;&gt; log scanned up to (178807644573)
  ....
  140224 00:05:34  innobackupex: completed OK!
  </code></pre>
  
  <h1>Result</h1>
  
  <p>However, the result is too small compared to original database files:</p>
  
  <pre><code># Source database
  # du -sm /var/lib/mysql/
  19G     /var/lib/mysql/
  
  # Xtrabackup result
  # du -sm /nobackup/xtrabackup
  455M    /nobackup/xtrabackup
  </code></pre>
  
  <h1>Can Xtrabackup handle databases with innodb_file_per_table?</h1>
  
  <p>My InnoDB configuration (in <code>/path/to/my.cnf</code>) are as following: </p>
  
  <pre><code>innodb_file_per_table
  innodb_file_format=Barracuda
  </code></pre>
  
  <p>Looking at the execution log, it shows the program only copied <code>ibdata1</code> but not other many *.idb files. </p>
  
  <p>I wonder if Xtrabackup cannot handle databases stored with <code>innodb_file_per_table</code>. I couldn’t find any hints in its documentation.</p>
  
  <p>Is that true, or any solutions/ideas?</p>
  
  <h1>edit 1: The result seems not to be compressed</h1>
  
  <pre><code># find /nobackup/xtrabackup
  /nobackup/xtrabackup
  /nobackup/xtrabackup/2014-02-24_00-04-21
  /nobackup/xtrabackup/2014-02-24_00-04-21/xtrabackup_logfile
  /nobackup/xtrabackup/2014-02-24_00-04-21/ibdata1
  /nobackup/xtrabackup/2014-02-24_00-04-21/xtrabackup_checkpoints
  /nobackup/xtrabackup/2014-02-24_00-04-21/backup-my.cnf
  /nobackup/xtrabackup/2014-02-24_00-04-21/2014-02-24_00-04-21
  /nobackup/xtrabackup/2014-02-24_00-04-21/xtrabackup_binary
  </code></pre>