backup_elevation

If this variable is enabled, BACKUP DATABASE internally elevates privileges to allow the backup to succeed even if the user does not have all the privileges required to access all objects to be included in the backup image. If the variable is disabled, privilege elevation does not occur and an error occurs if the user does not have privileges to access all objects.

backup_history_log

Whether the MySQL Backup history log is enabled. The value can be 0 (or OFF) to disable the log or 1 (or ON) to enable the log. The destination for log output is controlled by the log_backup_output system variable; if its value is NONE, no log entries are written even if the log is enabled.

backup_history_log_file

The name of the MySQL Backup history log file. The default value is backup_history.log in the data directory.

backup_progress_log

Whether the MySQL Backup progress log is enabled. The value can be 0 (or OFF) to disable the log or 1 (or ON) to enable the log. The destination for log output is controlled by the log_backup_output system variable; if its value is NONE, no log entries are written even if the log is enabled.

backup_progress_log_file

The name of the MySQL Backup progress log file. The default value is backup_progress.log in the data directory.

backupdir

The path to the default image file directory for BACKUP DATABASE and RESTORE operations. If an image file is named as a relative path name, it is interpreted relative to the value of backupdir. If the value of backupdir is itself a relative path name, its value is interpreted relative to the data directory. The default value is the data directory.

If backupdir is set to a nonexistent path, BACKUP DATABASE and RESTORE cannot be executed. The same is true if backupdir references a symbolic link that points at a nonexistent path. Specifying the backup image file name as an absolute path name does not help.

If backupdir is set to an existing plain file or pipe, BACKUP DATABASE and RESTORE fail if the value is a relative path, unless it starts with a leading ../ component or unless the backup image file name is given as an absolute path. The same is true if backupdir references a symbolic link that points at an existent plain file or pipe.

log_backup_output

The destination for MySQL Backup history and progress log output. The value can be a comma-separated list of one or more of the words TABLE (log to tables), FILE (log to files), or NONE (do not log to tables or files). The default value is TABLE. NONE, if present, takes precedence over any other specifiers. If the value is NONE log entries are not written even if the logs are enabled. If the logs are not enabled, no logging occurs even if the value of log_backup_output is not NONE. For more information, see Section 1.7.1, “MySQL Backup Log Control”.

restore_disables_events

If this variable is enabled (the default), RESTORE disables Event Scheduler events that are restored from the backup image. If the variable is disabled, restored events retain their state as recorded in the image.

restore_elevation

If this variable is enabled (the default), RESTORE internally elevates privileges to allow the restore to succeed even if the user does not have all the privileges required to create all objects in the backup image. If the variable is disabled, privilege elevation does not occur and an error occurs if the user does not have privileges to create all objects.

restore_precheck

This variable applies when restore_elevation is OFF. In that case, if restore_precheck is enabled (the default), RESTORE attempts to determine whether the user has all privileges required and fails if not. If restore_precheck is disabled, this check is skipped and the restore operation could fail in the middle due to errors resulting from insufficient privileges.

secure_backup_file_priv

By default, this variable is empty. If set to the name of a directory, it 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.