Homepage > Man Pages > Category > Maintenance Commands
Homepage > Man Pages > Name > A


man page of automysqlbackup

automysqlbackup: backup all of your database daily, weekly, and monthly

automysqlbackup - backup all of your database daily, weekly, and monthly


This manual page documents briefly the automysqlbackup command. configuration is stored within the /etc/default/automysqlbackup file


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)


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)


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. AUTOMYSQLBACKUP(8)

Copyright © 2011–2018 by topics-of-interest.com . All rights reserved. Hosted by all-inkl.
Contact · Imprint · Privacy

Page generated in 26.52ms.

get-ip.de | Brauche ich eine Unfallversicherung? | brieftaubenversteigerung.com