--log-backup-output[=value,...]

This option determines the destination for MySQL Backup history and progress log output. The option value can be given as one or more of the words TABLE, FILE, or NONE. If the option is not given or is given without a value, the default is TABLE. TABLE selects logging to the backup_history and backup_progress log tables in the mysql database as a destination. FILE selects logging to log files as a destination. NONE disables logging. If NONE is present in the option value, it takes precedence over any other words that are present. TABLE and FILE can both be given to select to both log output destinations.

This option selects log output destinations, but does not enable log output. To do that, set the --backup_history_log and --backup_progress_log system variables. For FILE logging, the default log files are backup_history.log and backup_progress.log in the data directory. To change the names, set the global backup_history_log_file and backup_progress_log_file system variables. For more information, see Section 1.7.1, “MySQL Backup Log Control”.

--mysql-backup[={0|1}]

By default, MySQL Backup capabilities provided by the BACKUP DATABASE and RESTORE statements are disabled. When given without a value, this option enables MySQL Backup. An optional value of 0 or 1 may be given to explicitly disable or enable MySQL Backup.

--secure-backup-file-priv=path

This option limits the effect of MySQL Backup statements to work only with image files in the specified directory. That is, the location for an image file to be written by BACKUP DATABASE or read by RESTORE must be in this directory.