The standard options are options of a general nature, or options that are not classified under any other specific option group:
The following standard options also exist for the mysql command. Full descriptions for these options can be found in the MySQL reference manual, accessible through, e.g., Server Option and Variable Reference. These options must be specified ahead of any other mysqlbackup options, including the rest of the standard options:
--print-defaultsPrint the program argument list and exit.
--no-defaultsDon't read default options from any option file.
--defaults-file=Only read default options from the given file. It has to be the first option to be specified, if used.
--defaults-extra-file=Read this file after the global files are read.
--defaults-group-suffix=Also read option groups with the usual names and a suffix of
The following options are also common between mysqlbackup and mysql, and full descriptions for them can be found in the MySQL reference manual, accessible through, e.g., Server Option and Variable Reference. However, mysqlbackup does not accept any short forms for these options as mysql does (for example, you must use
More standard options are available for mysqlbackup:
Overwriting of InnoDB data and log files during the
When restoring a TTS backup, changing temporarily the value of
innodb_file_formaton the server, in order to allow restores of per-table InnoDB data files regardless of their format.
Replacing of an image file during an
Restoring a partial image backup created with MySQL Enterprise Backup 3.11 or earlier; the
--forceoption is required, due to a known issue (Bug# 20485910).
Restoring a backup onto a server where the directory pointed to by the
.blfile in the backup (a copy of the
.islfile from the backed-up server) already contains
For all other operations, the
--forceoption is rejected with an error message.
Permitted Values Type enumeration Default
Trace level of mysqlbackup messages. The permissible levels, in the order of increasing fineness, are:
0 - INFO (information, warnings, errors)
1 - FINE (more information given than at trace level 0)
2 - FINER (finer level of information given than at trace level 1)
3 - FINEST (finest level of information that can be given)