Rechercher une page de manuel
automysqlbackup
Langue: en
Version: 364559 (ubuntu - 25/10/10)
Section: 8 (Commandes administrateur)
NAME
automysqlbackup - backup all of your database daily, weekly, and monthlySYNOPSIS
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.Contenus ©2006-2024 Benjamin Poulain
Design ©2006-2024 Maxime Vantorre