MySQL Enterprise Backup User's Guide (Version 3.12.5)
These operations bring the backup files up-to-date with any
changes to InnoDB tables that happened while the backup was in
progress. Although for convenience you can combine this
operation with the initial backup using the
backup-and-apply-log
command, you
must run the steps separately when performing incremental
backups.
mysqlbackup [STD-OPTIONS] [--limit-memory
=MB
] [--uncompress
] [--backup-dir
=PATH
] [MESSAGE-LOGGING-OPTIONS] [PROGRESS-REPORT-OPTIONS]apply-log
mysqlbackup [STD-OPTIONS] [--incremental-backup-dir
=PATH
] [--backup-dir
=PATH
] [--limit-memory
=MB
] [--uncompress
] [MESSAGE-LOGGING-OPTIONS] [PROGRESS-REPORT-OPTIONS]apply-incremental-backup
Example 13.1 Apply Log to Full Backup
mysqlbackup --backup-dir=/path/to/backup apply-log
It reads the backup-my.cnf
file inside
backup-dir
to understand the
backup. The my.cnf
defaults files have no
effect other than supplying the
limit-memory=
value, which limits usage of memory while doing the
MB
apply-log
operation.
Because the apply-log operation does not apply to incremental
backups, no incremental-backup-dir
is needed for this operation.
You can also perform apply-log
and
copy-back
(which restores the
prepared backup) together with a single
copy-back-and-apply-log
command.