Download MySQL Enterprise Backup User`s Guide (Version 3.11.1)
Transcript
mysqlbackup Command-Line Options Format Description Introduced --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-innodb-with-frm [Legacy] Back up only InnoDB data, log files, and the .frm files associated with the InnoDB tables. --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 3.11.0 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. --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-index Specifies the absolute path of the index file on the MySQL server that lists all the used relay log files (for offline backups of salve servers only). 3.11.0 --relaylog-info-file Specifies the absolute path of the information file in which a slave records information about the relay logs (for offline backups of salve servers only). 3.11.0 --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. --secure-auth Refuse client connecting to server if it uses old (pre-4.1.1) protocol. --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). 62 3.11.0