File mysql-backup.sysconfig of Package mysql-backupscript
## Path: System/Backup ## Description: ## Type: yesno ## Default: yes # # Start backup script. # START_BACKUP="yes" ## Type: string ## Default: /root/backup/db # # Place where the database backup files should be # stored. The path will be created if it doesn't # exist. # BACKUPDIR="/root/backup/mysql" ## Type: string ## Default: root@localhost # # Email address to send errors. # EMAIL="root@localhost" ## Type: string ## Default: /var/log/mysql-backup.log # # Logfile # LOGFILE="/var/log/mysql-backup.log" ## Type: integer ## Default: 14 # # Retention period for storing old backup files. # Files older than this value in $BACKUPDIR will # be deleted. # Set to '0' if you want to store all backups. # RETENTION=14 ## Type: yesno ## Default: no # # The script can try to repair and optimize the databases/tables # automatically after a successful backup. It uses mariadb-check for # all databases to do this. # OPTIMIZE_DB="no" ## Type: list(yes,no,skip) ## Default: yes # # Should the BACKUPDIR created if it does not exist? # yes : the script will create the backup directory # no : the script will abort and create an Email alert if the # backup directory does not exist # skip : the script will silently abort - useful if you run a # HA setup for the database # CREATE_BACKUPDIR="yes" ## Type: string ## Default: /usr/bin/xz # # Which executable should be used to compress the SQL dump files? # The executable should accept a filename as option on the command # line - like /usr/bin/bzip2 or /usr/bin/xz # # Please check that the executable exists before changing anything # here. If the file is not executable, the script will still run, # but not compress the SQL dump files at all. # COMPRESS_EXE='/usr/bin/xz' ## Type: yesno ## Default: no # # Should the compresssion run only after the post dump scripts # have run. Defaults to "no" to match previous behaviour. # Please note that this means all database dumps exist uncompressed # in parallel before compression while the dumps and the post # dump scripts, usually unlocking the database, are run. COMPRESS_AFTER_UNLOCK="no" ## Type: string ## Default: --defaults-extra-file=/root/.my.cnf # # Additional options added to each mysql* call. # Please note the following binaries are extended with the given options: # + mariadb-check # + mariadb-admin # + mariadb-dump # + mariadb # Options given here should be recognized by all the above binaries. # MYSQL_OPTS='--defaults-extra-file=/root/.my.cnf' ## Type: string ## Default: '' # # If you need to run extra commands before the real mariadb-dump starts, # please add the full path to your script here. # # There are two example scripts in # /usr/share/doc/packages/mysql-backupscript/examples/ # which can be used to stop a classical slave during a backup # or allow a Galera node to get temporary out of sync with the # rest of the cluster - so the backup can be faster and consistent. # MYSQL_SCRIPT_BEFORE_DUMP='' ## Type: string ## Default: '' # # If you need to run extra commands after the real mariadb-dump finished, # please add the full path to your script here. # # There are two example scripts in # /usr/share/doc/packages/mysql-backupscript/examples/ # which can be used to start a classical slave during a backup # or allow a Galera node to get synced again with the rest of the # cluster. # MYSQL_SCRIPT_AFTER_DUMP='' ## Type: yesno ## Default: no # # Use NSCA to send messages from the backup to your monitoring. # Please check/configure the other NSCA values here as well in # case you want to use it. # USE_NSCA='no' ## Type: string ## Default: '/etc/send_nsca.cfg' # # The path to the nsca configuration file. # SEND_NSCA_CONFIG='/etc/send_nsca.cfg' ## Type: string ## Default: '/usr/bin/send_nsca' # # The path to the nsca binary. # SEND_NSCA_BIN='/usr/bin/send_nsca' ## Type: string ## Default: '' # # The hostname used in the NSCA messages. # This name needs to be the same as configured in your # monitoring server for this machine. # Fallback is the output of the: 'hostname -s' command. # SEND_NSCA_HOSTNAME='' ## Type: string ## Default: 'localhost' # # The hostname of your monitoring server. # You can use any resolvable name or IP address here. # NSCA will try to send messages to this address. # NAGIOSHOST='localhost' ## Type: string ## Default: 'MySQL backup' # # The name of the service, configured on your monitoring server. # Please make sure that the server name configured here is the same # as the one your monitoring server shows in the WebUI. # If any of 'SEND_NSCA_HOSTNAME' or 'NAGIOS_SERVICE_NAME' are not # identical on both systems, the messages from NSCA will be ignored. # NAGIOS_SERVICE_NAME='MySQL backup' ## Type: yesno ## Default: yes # # Use Email to send messages from the backup script. # This is enabled by default. # USE_EMAIL='yes' ## Type: string ## Default: 'root@localhost' # # The Email address to send notification Emails to. # Default is 'root@localhost', which in turn normally is aliased # to your real address via /etc/aliases # EMAIL='root@localhost' ## Type: string ## Default: "--add-drop-database --add-drop-table --add-drop-trigger --apply-slave-statements --default-character-set=utf8mb4 --dump-date --events --extended-insert --flush-logs --flush-privileges --include-master-host-port --master-data --opt --quick --quote-names --routines --single-transaction" # # The default options used for mariadb-dump. # Please note that these options are optimized for large InnoDB tables. # For better readability, below are the default options separated by lines: # --add-drop-database \ # --add-drop-table \ # --add-drop-trigger \ # --apply-slave-statements \ # --default-character-set=utf8mb4 \ # --dump-date \ # --events \ # --extended-insert \ # --flush-logs \ # --flush-privileges \ # --include-master-host-port \ # --master-data \ # --opt \ # --quick \ # --quote-names \ # --routines \ # --single-transaction" # DUMP_OPTIONS="--add-drop-database --add-drop-table --add-drop-trigger --apply-slave-statements --default-character-set=utf8mb4 --dump-date --events --extended-insert --flush-logs --flush-privileges --include-master-host-port --master-data=2 --opt --quick --quote-names --routines --single-transaction"
