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