man automysqlbackup Command

Man page for apt-get automysqlbackup Command

Man Page for automysqlbackup in Linux

This tutorial shows the man page for man automysqlbackup in linux.

Open terminal with 'su' access and type the command as shown below:
man automysqlbackup

Result of the Command Execution shown below:

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 seperate 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.

       

Related Topics