---
name: "automysqlbackup"
section: "8"
platform: "linux"
package: "automysqlbackup"
version: "2.6+debian.4-4"
release: "Debian 13 (Trixie)"
platforms: ["linux"]
url: "https://new.carta.tech/automysqlbackup"
---

# automysqlbackup(8)

backup all of your database daily, weekly, and monthly

## 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.**