Install the automysqlbackup utility.
None.
Variables
# database username and password that will perform the backups
automysqlbackup_username: "$(grep user /etc/mysql/debian.cnf | tail -n 1 | cut -d'=' -f2 | awk '{print $1}')"
automysqlbackup_password: "$(grep password /etc/mysql/debian.cnf | tail -n 1 | cut -d'=' -f2 | awk '{print $1}')"
# hostname or ip address of the database server
automysqlbackup_host: localhost
# space separated string of databases to include or ignore in the backup
automysqlbackup_dbames: "all"
automysqlbackup_dbexclude: ""
# whether to include a create database statement
automysqlbackup_createdb_stmt: "yes"
automysqlbackup_backup_directory: /var/lib/automysqlbackup
# backup each database in a separate directory or everything to a single file
automysqlbackup_sepdir: "yes"
# day of the week for weekly backbackups (6 - Saturday)
automysqlbackup_doweekly: 6
# output location (log, files, stdout, quiet) and where output is sent (user / email address)
automysqlbackup_mailcontent: quiet
automysqlbackup_mailaddr: root
# default cron configuration
automysqlbackup_cron:
minute: 0
hour: 0
day: "*"
month: "*"
weekday: "*"
# latest
automysqlbackup_latest: "no"
MIT