Documentation Home
MySQL Enterprise Backup 3.9 User's Guide
Related Documentation Download this Manual
PDF (US Ltr) - 0.9Mb
PDF (A4) - 0.8Mb Backup Operations

The backup operations are the most frequently performed tasks by MySQL Enterprise Backup. Various kinds of backups can be performed by adding different options, like using --compress or --incremental for compressed or incremental backups. Here is the syntax for the mysqlbackup command for performing a backup operation:

mysqlbackup [STD-OPTIONS]
            backup | backup-and-apply-log | backup-to-image
  • backup

    Performs the initial phase of a backup. The second phase is performed later by running mysqlbackup again with the apply-log option.

  • backup-and-apply-log

    A combination of backup and apply-log. Not compatible with incremental backups. Also incompatible with the --compress option.

  • backup-to-image

    Produces a single-file backup rather than a directory structure holding the backup files. Requires the --backup-image option to specify the destination file. Can be used to stream the backup to a storage device or another system without ever storing the data on the database server. You can specify --backup-image=-, representing standard output, allowing the output to be piped to another command. To avoid mixing normal informational messages with backup output, the --help message, errors, alerts, and normal informational messages are always printed to standard error.

Example 4.1 Simple Backup with Connection Parameters from Default Configuration File

The following example shows a minimal backup with the mysqlbackup command, with any necessary connection parameters for the database in the [mysqlbackup] section of the default MySQL configuration file:

mysqlbackup --backup-dir=/export/backups/latest backup

Example 4.2 Basic Incremental Backup

mysqlbackup --incremental --start-lsn=12345 --incremental-backup-dir=/path/to/incbackup backup

There is a separate directory dedicated to incremental backup. Both this directory and the one for full backups can be specified in the my.cnf file, and the appropriate directory is used depending on the type of backup. Both the incremental backup data and an earlier full backup are needed to do a successful restore operation.

User Comments
Sign Up Login You must be logged in to post a comment.