Documentation Home
MySQL Enterprise Backup 4.1 User's Guide
Related Documentation Download this Manual
PDF (US Ltr) - 1.3Mb
PDF (A4) - 1.3Mb
HTML Download (TGZ) - 194.0Kb
HTML Download (Zip) - 223.4Kb

4.3.4 Making a Compressed Backup

To save disk space, you can compress InnoDB backup data files by using the --compress option of mysqlbackup. Compression lets you keep more sets of backup data on hand or save transmission time when sending the backup data to another server. Also, compression often results in faster backups because of reduced IO.

The backup compression feature works only for InnoDB tables. After the InnoDB tablespace files are compressed during backup, they receive the .ibz extension. To avoid wasting CPU cycles without saving additional disk space, --compress does not attempt to compress tables that were already-compressed on the server (see Creating Compressed Tables); nevertheless, such tablespace files are also saved with the .ibz extension inside the backup.


When there is unused space within an InnoDB tablespace file, the entire file is copied during an uncompressed backup. Perform a compressed backup to avoid the storage overhead for the unused space.

The binary log and relay log files are compressed and saved with the .bz extension when being included in a compressed backup.

You can only use the --compress option for full backups, not for incremental backups.

You can also select the compression algorithm to use by the --compress-method option and, when using the ZLIB or LZMA compression algorithm, the level of compression by the --compress-level option. See Section 16.6, “Compression Options” for details.

This is a sample command for making a compressed single-file backup:

mysqlbackup --defaults-file=/etc/my.cnf --compress --compress-level=5 \
  --backup-image=backup.img backup-to-image

Advanced: This is a sample command for making a compressed directory backup:

mysqlbackup --defaults-file=/etc/my.cnf --compress --compress-level=5 backup

This is a sample command for making a compressed and prepared directory backup (only supported for MySQL Enterprise Backup 4.0.1 and later):

mysqlbackup --defaults-file=/etc/my.cnf --compress --compress-level=5 backup-and-apply-log

User Comments
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
Sign Up Login You must be logged in to post a comment.