default.cnf

# Default mysql-backup configuration

# Backup options
BACKUP_DIR=/var/lib/mysql-backup
DATABASES="ALL"
IGNORE_DATABASES=(information_schema)
COMPRESSION=gzip
COMPRESSION_OPTS=
DAILY_RETENTION=7
WEEKLY_DAY="1"
WEEKLY_RETENTION=35
MONTHLY_DAY="01"
MONTHLY_RETENTION=365
HOST=$(hostname)

# Dump hooks
pre_dump_backup_hook=
post_dump_backup_hook=
pre_dump_restore_hook=
post_dump_restore_hook=

# Snapshot hooks
pre_snapshot_backup_hook=
post_snapshot_backup_hook=
pre_snapshot_backup_lvm_snaphost_hook=
post_snapshot_backup_lvm_snaphost_hook=
pre_snapshot_backup_archive_hook=
post_snapshot_backup_archive_hook=


# mysql / mysqldump default configuration

# uncomment next line if host is different than $HOST
# host=127.0.0.1
# SOCKET protocol is a more secure way for sql backups.
proto=SOCKET
batch=1
skip_column_names=1
quote_names=1
opt=1
add_drop_database=1