备份操作：backup, backup-and-apply-log, backup-to-image.

恢复操作：copy-back, copy-back-and-apply-log.

--backup-image=IMAGE

指定用于单文件备份、还原或其他 单文件操作的文件的路径名。

除了使用 流式传输备份图像时 --backup-image=-，如果--backup-image没有给出完整路径名，这就是 mysqlbackup解释选项值的方式：

By default, the single-file backup is streamed to standard output, so that you can pipe it directly to other commands such as a tape backup or an ssh-related network command.

You can optionally prefix the image name with file: to signify a file I/O (the default). For tape backups, prefix the image name with sbt:. See Section 4.3.1.2, “Backing Up to Tape” for details about tape backups.

--backup_dir=PATH

Same as --backup-dir. The backup directory under which the backup data and metadata are stored, permanently or temporarily. It is a crucial parameter required for most kinds of backup and restore operations.

The option is used differently for different operations and under different situations:

backup_innodb_data_home_dir=PATH

The directory under which the backup's InnoDB data files are to be stored. Specify the option if you want to put the data files at somewhere other than the default location (which is backup-dir/datadir). If the value of the parameter is different from backup-dir/datadir, it is stored into the backup-my.cnf file as innodb_data_home_dir for information, so that mysqlbackup can understand the structure of the backup when it performs various operations on the backup. Together with backup_innodb_data_file_path option, it determines the actual file paths of the InnoDB data files inside the backup.

The value for the parameter is derived as follows:

This parameter is applicable only for backup operations; during a restore, the InnoDB data files are restored under the data directory specified by --datadir, unless another location is specified using the --innodb_data_home_dir option during restore.

backup_innodb_data_file_path=VALUE

The InnoDB data file names and sizes. Examples:

ibdata1:32M;ibdata2:32M:autoextend
/abs/path/ibdata1:32M:autoextend
innodb-dir/ibdata1:32M:autoextend

This parameter, together with backup_innodb_data_home_dir, determines where the InnoDB data files are stored within the backup repository. Any file path specified with this option is taken to be relative to the value of the backup_innodb_data_home_dir option (that is true even if the file path is specified in the form of an absolute path, like /abs/path/ibdata1:32M:autoextend). To specify truly absolute paths for InnoDB data files in the backup with this option, you must set the backup_innodb_data_home option to "" [empty string], in addition to using an absolute path for this option.

When the parameter is not specified, it inherits the value from the value of the innodb_data_file_path option on the backed-up server. If both the source and destination of the backup attempt to use the same absolute paths that resolves to the same files, the backup is cancelled.

The value of the parameter is stored into the backup-my.cnf file as innodb_data_file_path for information, so that mysqlbackup can understand the structure of the backup when it performs various operations on the backup.

backup_innodb_log_group_home_dir=PATH

The directory under which the backup's InnoDB logs will be stored. Specify this option only if you want to put the logs at somewhere other than the default location (which is backup-dir/datadir). If the value of the parameter is different from backup-dir/datadir, it is stored in the backup-my.cnf file as innodb_log_group_home_dir for information, so that mysqlbackup can understand the structure of the backup when it performs various operations on the backup. Note that while you can specify a directory for saving the logs, the names of the log files are fixed and not reconfigurable.

This parameter is applicable only for backup operations; during a restore, the InnoDB log files are restored under the data directory specified by --datadir, unless another location is specified using the --innodb_log_group_home_dir option during restore. The value of the parameter is derived as follows:

backup_innodb_undo_directory=PATH

The relative or absolute directory path where separate tablespaces are created for the InnoDB undo logs during the backup. When unspecified, the option takes up the same value as backup_innodb_log_group_home_dir; specify this option only if you want to put the undo logs at some other location. If the value of the parameter is different from backup-dir/datadir, it is stored in the backup-my.cnf file as innodb_undo_directory for information, so that mysqlbackup can understand the structure of the backup when it performs various operations on the backup.

This parameter is applicable only for backup operations; during a restore, the InnoDB undo log tablespaces are restored under the data directory specified by --datadir, unless another location is specified by the --innodb_undo_directory option during restore.

--with-timestamp

Creates a subdirectory underneath the backup directory, with a name formed with the timestamp of the backup operation. It is useful for maintaining a single backup directory containing many backup snapshots put under different subdirectories.

Default: no timestamped subdirectory is created. To reuse the same backup directory for a new backup without using this option, either remove the previous backup files manually or, for a single-file backup, specify the --force option to overwrite the old backup file.

backup_innodb_log_files_in_group=N

The number of InnoDB log files in a log group on the restored server. See the description for innodb_log_files_in_group in the MySQL server manual. The value for this parameter, saved as innodb_log_files_in_group in the backup-my.cnf file, is derived as follows:

backup_innodb_log_file_size=SIZE

The maximum single InnoDB log file size in backup before switching to next log file, on the restored server. See the description for innodb_log_file_size in the MySQL server manual. The value for this parameter, saved as innodb_log_file_size in the backup-my.cnf file, is derived as follows:

backup_innodb_page_size=SIZE

Specifies, for an offline backup, the page size for all InnoDB tablespaces on the restored server. This option should be specified carefully, because the page size must be the same as that of the backed up MySQL instance, or the backup could become useless. For an online backup, the value is taken from the value of the innodb_page_size option on the backed-up server.

Value of this option is saved in the backup-my.cnf file, to be used for restoring the database.

backup_innodb_undo_logs=NUMBER

Specifies, for an offline backup, the number of rollback segments in the InnoDB system tablespace on the restored server. This option should be specified carefully, because the value must be the same as that of innodb_undo_logs on the backed-up MySQL instance, or the backup could become useless. For an online backup, the value for the parameter is taken from the value of the innodb_undo_logs option on the backed-up server.

backup_innodb_undo_tablespaces=NUMBER

Specifies the number of tablespace files that the undo logs are divided between, when you use a non-zero backup_innodb_undo_logs setting. This option should be specified carefully, because the value must be the same as that of innodb_undo_tablespaces on the backed-up MySQL instance, or the backup could become useless. For an online backup, the value for the parameter is taken from the value of the innodb_undo_tablespaces option on the backed-up server. By default, all the undo logs are part of the system tablespace, and the system tablespace will always contain one undo tablespace in addition to those configured by innodb_undo_tablespaces.

backup_innodb_checksum_algorithm=NAME

Specifies, for an offline backup, the name of the checksum algorithm used for validating the InnoDB tablespaces on the restored server. This option should be specified carefully, because the checksum algorithm must be the same use on the backed-up MySQL instance, or the backup could become useless. For an online backup, the value is taken from the value of the innodb_checksum_algorithm option on the backed-up server.

Default value of the option is “innodb”.

Value of this option is saved in the backup-my.cnf file, to be used for restoring the database.