Restore a compressed directory backup at
<backupDir>
to
<restoreDir>
on the server using
copy-back-and-apply-log
and the
--uncompress
option:
Example 5.7 Restoring a Compressed Backup
mysqlbackup --defaults-file=<my.cnf> -uroot --backup-dir=<backupDir> --datadir=<restoreDir> \
--uncompress copy-back-and-apply-log
To restore a compressed and
prepared directory
backup created with the
backup-and-apply-log command
(which is only supported for MySQL Enterprise Backup 3.12.3 and later), use the
copy-back
command and the
--uncompress
option:
mysqlbackup --defaults-file=<my.cnf> -uroot --backup-dir=<backupDir> --datadir=<restoreDir> \
--uncompress copy-back
To restore a compressed backup image named
<image_name>
, use the
copy-back-and-apply-log
command
and the --uncompress
option, with
the --backup-dir
option specifying
a temporary directory into which temporary output, status
files, and backup metadata will be saved:
mysqlbackup --defaults-file=<my.cnf> -uroot --backup-image=<image_name> \
--backup-dir=<backupTmpDir> --datadir=<restoreDir> --uncompress copy-back-and-apply-log
See Section 4.3.3, “Making a Compressed Backup” and Section 14.6, “Compression Options” for more details on compressed backups.