Poster of Linux kernelThe best gift for a Linux geek
automysqlbackup

automysqlbackup

Section: Automatically backup MySQL (8) Updated: 6 Sep 2008
Local index Up
 

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.


 

Index

NAME
SYNOPSIS
DESCRIPTION
PARAMETERS
ADVANCED OPTIONS
AUTHOR

This document was created by man2html, using the manual pages.
Time: 22:01:18 GMT, April 16, 2011