MySQL Enterprise Backup 8.0 User's Guide / mysqlbackup Command Reference / mysqlbackup Command-Line Options
Table of Contents
- 20.1 General Options
- 20.2 Connection Options
- 20.3 Server Repository Options
- 20.4 Backup Repository Options
- 20.5 Metadata Options
- 20.6 Compression Options
- 20.7 Incremental Backup Options
- 20.8 Partial Backup and Restore Options
- 20.9 Single-File Backup Options
- 20.10 Performance / Scalability / Capacity Options
- 20.11 Message Logging Options
- 20.12 Progress Report Options
- 20.13 Encryption Options
- 20.14 Options for Working with Encrypted InnoDB Tablespaces and EncryptedBinary/Relay Logs
- 20.15 Cloud Storage Options
- 20.16 Options for Special Backup Types
The following sections describe the command-line options for the different modes of operation ofmysqlbackup.
The table below list all the command options formysqlbackup. Use the hyperlinks at the option names to jump to the detailed descriptions for the options.
Note
The command options can also be specified in configuration files; see explanations inChapter 21,Configuration Files and Parameters.mysqlbackup follows the MySQL standard practice for handling duplicate options, whether specified in a configuration file, on the command line, or both. Options are processed first from configuration files, then from the command line. If an option is specified more than once, the last instance takes precedence.
Table 20.1 List of All Options
| Option Name | Description | Introduced | Deprecated | Removed |
|---|---|---|---|---|
| --backup-dir | The directory to store the backup data. | |||
| --backup-image | Specifies the path name of the backup image. | |||
| --backup_innodb_data_file_path | Specifies Innodb system tablespace files' path and size in backup. | |||
| --backup_innodb_data_home_dir | Backup base directory for all InnoDB data files in the system tablespace. | |||
| --backup_innodb_log_group_home_dir | Backup directory for InnoDB log files. | |||
| --backup_innodb_undo_directory | The relative or absolute directory path where InnoDB creates separate tablespaces for the undo logs. | |||
| --character-sets-dir | Directory for character set files. | |||
| --cloud-access-key | Access key for the cloud account. | 8.0.23 | ||
| --cloud-access-key-id | AWS access key ID for logging onto Amazon S3. | |||
| --cloud-aws-region | Region for Amazon Web Services that mysqlbackup access for S3. | |||
| --cloud-basicauth-url | The URL for HTTP Basic Authentication for accessing Swift. | |||
| --cloud-bucket | The storage bucket for the backup image. | |||
| --cloud-buffer-size | Size of buffer for cloud operations. | |||
| --cloud-ca-info | Absolute path to the CA bundle file for host authentication for SSL connections. | |||
| --cloud-ca-path | CA certificate directory, in addition to the system's default folder. | |||
| --cloud-chunk-size | The size of a chunk in megabytes if chunked transfer is enabled. | 8.0.23 | ||
| --cloud-chunked-transfer | Use chunked transfer with cloud storage service. | |||
| --cloud-container | The Swift container for the backup image. | |||
| --cloud-host | The hostname for a storage service. | 8.0.22 | ||
| --cloud-identity-url | The URL of the Keystone identity service. | |||
| --cloud-object | The storage object for the backup image. | |||
| --cloud-object-key | The Amazon S3 object key for the backup image. | |||
| --cloud-par-url | Pre-Authenticated Request URL for OCI Object Storage | 8.0.22 | ||
| --cloud-password | Password for user specified by --cloud-user-id. | |||
| --cloud-proxy | Proxy address and port number for overriding the environment's default proxy settings for accessing cloud service. | |||
| --cloud-region | The Keystone region for the user specified by --cloud-user-id. | |||
| --cloud-secret-access-key | AWS secret access key. | |||
| --cloud-secret-key | Secret key for the cloud account. | 8.0.23 | ||
| --cloud-service | Cloud service for data backup or restoration. | |||
| --cloud-tempauth-url | The URL of the identity service for authenticating user credentials with Swift's TempAuth authentication system. | |||
| --cloud-tenant | The Keystone tenant for the user specified by --cloud-user-id. | |||
| --cloud-trace | Print trace information for cloud operations. | |||
| --cloud-user-id | User ID for accessing Swift. | |||
| --comments | Specifies comments string. | |||
| --comments-file | Specifies path to comments file. | |||
| --compress | Create backup in compressed format. | |||
| --compress-level | Specifies the level of compression. | |||
| --compress-method | Specifies the compression algorithm. | |||
| --compression-algorithms | Permitted compression algorithms for connections to server | 8.0.18 | ||
| --connect_timeout | Connection timeout in seconds. | |||
| --datadir | Path to mysql server data directory. | |||
| --debug | Print debug information. | |||
| --decrypt | Decrypt backup image written in an MEB Secure File. | |||
| --default-character-set | Set the default character set. | |||
| --defaults-extra-file | Read this file after the global files are read. | |||
| --defaults-file | Only read default options from the given file. | |||
| --defaults-group-suffix | Also read option groups with the usual names and a suffix of str. | |||
| --disable-manifest | Disable generation of manifest files for a backup operation. | |||
| --dst-entry | Used with single-file backups to extract a single file or directory to a user-specified path. | |||
| --enable-cleartext-plugin | Enables the cleartext authentication plugin. | 8.0.22 | ||
| --encrypt | Encrypt backup image and write it in an MEB Secure File. | |||
| --encrypt-password | The user-supplied password by which mysqlbackup encrypts the encryption keys for encrypted InnoDB tablespaces. | |||
| --error-code | The exit code for which the print-message command prints the corresponding exit message. | |||
| --exclude-tables | Exclude in a backup or restore tables whose names match the regular expression REGEXP. | |||
| --exec-when-locked | Execute the specified utility in the lock phase near the end of the backup operation. | |||
| --force | Force overwriting of data, log, or image files, depending on the operation. | 8.0.28 | ||
| --free-os-buffers | Free filesystem cache by syncing the buffers | |||
| --help | Display help. | |||
| --host | Host name to connect. | |||
| --include | [Legacy] Backup only those per-table innodb data files which match the regular expression REGEXP. | 8.0.20 | ||
| --include-tables | Include in a backup or a restore tables whose names match the regular expression REGEXP. | |||
| --incremental | Specifies that the associated backup or backup-to-image operation is incremental. | |||
| --incremental-backup-dir | Specifies the location for an incremental directory backup. | |||
| --incremental-base | The specification of base backup for --incremental option. | |||
| --incremental-with-redo-log-only | Specifies the incremental backup of InnoDB tables to be based on copying redo log to the backup, without including any InnoDB data files in the backup. | |||
| --innodb_data_home_dir | Specifies base directory for all InnoDB data files in the shared system tablespace. | |||
| --innodb_log_group_home_dir | The directory path to InnoDB log files. | |||
| --innodb_undo_directory | The directory path to InnoDB undo tablespaces. | |||
| --key | The symmetric key used for encryption and decryption. | |||
| --key-file | The pathname of a file that contains the symmetric key used for encryption and decryption. | |||
| --limit-memory | The memory in MB available for the MEB operation. | |||
| --lock-wait-timeout | Specify the timeout in seconds for the FLUSH TABLES WITH READ LOCK statement that mysqlbackup issues during the final stage of a backup. | 8.0.16 | ||
| --log-bin | Specify the location for the binary log to be restored. | |||
| --log-bin-index | Specifies the absolute path of the index file that lists all the binary log files. | |||
| --login-path | Read options from the named login path in the .mylogin.cnf login file. | |||
| --messages-logdir | Specifies the path name of an existing directory for storing the message log. | |||
| --no-defaults | Do not read default options from any given file. | |||
| --no-history-logging | Disable history logging even if connection is available. | |||
| --no-locking | Disable all locking of tables during backups. | |||
| --no-redo-log-archive | Skip using redo log archiving during backups. | 8.0.17 | ||
| --number-of-buffers | Specifies the exact number of memory buffers to be used for the backup operation. | |||
| --on-disk-full | Specifies the behavior when a backup process encounters a disk-full condition. | |||
| --only-innodb | Back up only InnoDB data and log files. | |||
| --only-known-file-types | Includes only files of a list of known types in the backup. | |||
| --optimistic-busy-tables | Perform an optimistic backup, using the regular expression specified with the option to select tables that will be skipped in the first phase of an optimistic backup. | |||
| --optimistic-time | Perform an optimistic backup with the value specified with the option as the optimistic time—a time after which tables that have not been modified are believed to be inactive tables. | |||
| --page-reread-count | Maximum number of page re-reads. | |||
| --page-reread-time | Wait time before a page re-read. | |||
| --password | Connection password. | |||
| --pipe | alias for –protocol=pipe. | |||
| --plugin-dir | Specifies the directory for client-side plugins. | 8.0.22 | ||
| --port | TCP portnumber to connect to. | |||
| --print-defaults | Print a list of option values supplied by defaults files and exit. | |||
| --process-threads | Specifies the number of process-threads for the backup operation. | |||
| --progress-interval | Interval between progress reports in seconds. | |||
| --protocol | Connection protocol. | |||
| --read-threads | Specifies the number of read-threads for the backup operation. | |||
| --relay-log | Specify the location for the relay log to be restored on a replica server. | |||
| --relay-log-index | Specifies the absolute path of the index file that lists all the relay log files. | |||
| --rename | Rename a single table when it is selected by the --include-tables option to be restored | |||
| --replica-info | Capture information needed to set up an identical replica server. | 8.0.32 | ||
| --safe-replica-backup-timeout | When backing up a replica server, the timeout value for waiting for the replication SQL thread to drop its temporary tables. | 8.0.32 | ||
| --safe-slave-backup-timeout | When backing up a replica server, the timeout value for waiting for the replication SQL thread to drop its temporary tables. | 8.0.32 | ||
| --sbt-database-name | Used as a hint to the Media Management Software (MMS) for the selection of media and policies for tape backup. | |||
| --sbt-environment | Comma separated list of environment variable assignments to be given to the SBT library. | |||
| --sbt-lib-path | Path name of the SBT library used by software that manages tape backups. | |||
| --shared-memory-base-name | It designates the shared-memory name used by a Windows server to permit clients to connect using shared memory (Windows only). | |||
| --show-progress | Instructs mysqlbackup to periodically output short progress reports known as progress indicators on its operation. | |||
| --skip-binlog | Do not include binary log files during backup, or do not restore binary log files during restore. | |||
| --skip-final-rescan | Skip the final rescan for InnoDB tables that are modified by DDL operations. | |||
| --skip-messages-logdir | Disable logging to teelog file. | |||
| --skip-relaylog | Do not include relay log files during backup, or do not restore relay log files during a restore. | |||
| --skip-unused-pages | Skip unused pages in tablespaces when backing up InnoDB tables. | |||
| --slave-info | Capture information needed to set up an identical replica server. | 8.0.32 | ||
| --sleep | Time to sleep in milliseconds after copying each 1MB of data. | |||
| --socket | Socket file to use to connect. | |||
| --src-entry | Identifies a file or directory to extract from a single-file backup. | |||
| --ssl-ca | CA file in PEM format (implies –ssl). | |||
| --ssl-capath | CA directory (check OpenSSL docs,implies --ssl). | |||
| --ssl-cert | X509 cert in PEM format (implies --ssl). | |||
| --ssl-cipher | SSL cipher to use (implies --ssl). | |||
| --ssl-fips-mode | Controls whether MEB operates in FIPS mode. | 8.0.14 | ||
| --ssl-key | X509 key in PEM format (implies --ssl). | |||
| --ssl-mode | Security state of connection to server. | |||
| --start-lsn | Specifies the highest LSN value included in a previous backup. | |||
| --suspend-at-end | Pauses the mysqlbackup command when the backup procedure is close to ending. | |||
| --trace | Trace level of messages by mysqlbackup. | |||
| --uncompress | Uncompress a backup during an operation. | |||
| --use-tts | Enable selective backup of InnoDB tables using transportable tablespaces (TTS). | |||
| --user | Database server user name to connect. | |||
| --verbose | Print more verbose information. | |||
| --version | Display version information. | |||
| --with-timestamp | Create a subdirectory underneath the backup directory with a name formed from the timestamp of the backup operation. | |||
| --write-threads | Specifies the number of write-threads for the backup operation. | |||
| --zstd-compression-level | Compression level for connections to server that use ZSTD compression | 8.0.18 |