Limitations of xtrabackup

The xtrabackup binary has some limitations you should be aware of to ensure that your backups go smoothly and are recoverable.

  • If the xtrabackup_logfile is larger than 4GB, the --prepare step will fail on 32-bit versions of xtrabackup.
  • xtrabackup does not currently create new InnoDB log files (ib_logfile0, etc) during the initial --prepare step. You must prepare the backup a second time to do this, if you wish.
  • xtrabackup copies only the InnoDB data and logs. It does not copy table definition files (.frm files), MyISAM data, users, privileges, or any other portions of the overall database that lie outside of the InnoDB data. To back up this data, you need a wrapper script such as innobackupex.
  • xtrabackup doesn’t understand the very old --set-variable my.cnf syntax that MySQL uses. See Configuring xtrabackup.
Percona XtraBackup
Call Us
+1-888-316-9775 (USA - Sales)
+1-208-473-2904 (USA - Sales)
+44-208-133-0309 (UK - Sales)
0-800-051-8984 (UK - Sales)
0-800-181-0665 (GER - Sales)
+1-877-862-4316 (Emergency)
+1-855-55TRAIN (Training)
+1-925-271-5054 (Training)

Previous topic

Exporting and Importing Tables

Next topic

Implementation Details

This Page



© Copyright 2010-2012, Percona Ireland Ltd.
Except where otherwise noted, this documentation is licensed under the following license:
CC Attribution-ShareAlike 2.0 Generic
Created using Sphinx 1.1.3.
This documentation is developed in Launchpad as part of the Percona XtraBackup source code.
If you spotted innacuracies, errors, don't understood it or you think something is missing or should be improved, please file a bug.
]]>