Man page - automysqlbackup(8)

Packages contains this manual

Manual

automysqlbackup

NAME
SYNOPSIS
DESCRIPTION
PARAMETERS
ADVANCED OPTIONS
AUTHOR

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.