automysqlbackup

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="user@domain.com"
          Email Address to send mail to? (user@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)

AUTHOR

   This manual page was written by Jose Luis Tallon <jltallon@adv-solutions.net>.  for the Debian GNU/Linux system, but can be used by others.

wipe_out 6 Sep 2008 automysqlbackup(8)