AUTOMYSQLBACKUP(8) - man page online | administration and privileged commands
Backup all of your database daily, weekly, and monthly.
6 Sep 2008
automysqlbackup(8) Automatically backup MySQL automysqlbackup(8)
NAME automysqlbackup - backup all of your database daily, weekly, and monthly SYNOPSIS automysqlbackup DESCRIPTION This manual page documents briefly the automysqlbackup command. configuration is stored within the /etc/default/automysqlbackup file PARAMETERS USERNAME=dbuser Username to access the MySQL server e.g. dbuser PASSWORD="password" Username to access the MySQL server e.g. password DBHOST=localhost Host name (or IP address) of MySQL server e.g localhost DBNAMES="DB1 DB2 DB3" List of DBNAMES for Daily/Weekly Backup e.g. "DB1 DB2 DB3" BACKUPDIR="/backups" Backup directory location e.g /backups MAILCONTENT="stdout" Mail setup What would you like to be mailed to you? - log : send only log file - files : send log file and sql files as attachments (see docs) - stdout : will simply output the log to the screen if run manually. - quiet : Only send logs if an error occurs to the MAILADDR. MAXATTSIZE="4000" Set the maximum allowed email size in k. (4000 = approx 5MB email [see docs]) MAILADDR="@domain.com" Email Address to send mail to? (@domain.com) ADVANCED OPTIONS MDBNAMES="mysql $DBNAMES" List of DBBNAMES for Monthly Backups. DBEXCLUDE="" List of DBNAMES to EXCLUDE if DBNAMES are set to all (must be in " quotes) CREATE_DATABASE=yes Include CREATE DATABASE in backup? SEPDIR=yes Separate backup directory and file for each DB? (yes or no) DOWEEKLY=6 Which day do you want weekly backups at? (1 to 7 where 1 is Monday) COMP=gzip Choose Compression type. (gzip or bzip2) COMMCOMP=no Compress communications between backup server and MySQL server? LATEST=no Additionally keep a copy of the most recent backup in a separate directory. MAX_ALLOWED_PACKET= The maximum size of the buffer for client/server communication. e.g. 16MB (maximum i SOCKET= For connections to localhost. Sometimes the Unix socket file must be specified. #PREBACKUP="/etc/automysqlbackup/mysql-backup-pre" Command to run before backups (uncomment to use) #POSTBACKUP="/etc/automysqlbackup/mysql-backup-post" Command run after backups (uncomment to use)wipe_out 6 Sep 2008 automysqlbackup(8)