Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # By default, the Debian version of automysqlbackup will use:
- # mysqldump --defaults-file=/etc/mysql/my.cnf
- # but you might want to overwrite with a specific user & pass.
- # To do this, simply edit bellow.
- # Username to access the MySQL server e.g. dbuser
- #USERNAME=root
- # Username to access the MySQL server e.g. password
- #PASSWORD=root
- # Host name (or IP address) of MySQL server e.g localhost
- DBHOST="localhost"
- # List of DBNAMES for Daily/Weekly Backup e.g. "DB1 DB2 DB3"
- # Note that it's absolutely normal that the db named "mysql" is not in this
- # list, as it's added later by the script. See the MDBNAMES directives below
- # in this file (advanced options).
- # This is ONLY a convenient default, if you don't like it, don't complain
- # and write your own.
- # The following is a quick hack that will find the names of the databases by
- # reading the mysql folder content. Feel free to replace by something else.
- # DBNAMES=`find /var/lib/mysql -mindepth 1 -maxdepth 1 -type d | cut -d'/' -f5 | grep -v ^mysql\$ | tr \\\r\\\n ,\ `
- # This one does a list of dbs using a MySQL statement.
- DBNAMES="control_fletes"
- # Backup directory location e.g /backups
- # Folders inside this one will be created (daily, weekly, etc.), and the
- # subfolders will be database names. Note that backups will be owned by
- # root, with Unix rights 0600.
- BACKUPDIR="/home/pupa/perro"
- # 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.
- MAILCONTENT="quiet"
- # Set the maximum allowed email size in k. (4000 = approx 5MB email [see
- # docs])
- MAXATTSIZE="4000"
- # Email Address to send mail to? (user@domain.com)
- MAILADDR="root"
- # ============================================================
- # === ADVANCED OPTIONS ( Read the doc's below for details )===
- #=============================================================
- # List of DBBNAMES for Monthly Backups.
- MDBNAMES="mysql $DBNAMES"
- # List of DBNAMES to EXLUCDE if DBNAMES are set to all (must be in " quotes)
- DBEXCLUDE=""
- # Include CREATE DATABASE in backup?
- CREATE_DATABASE=yes
- # Separate backup directory and file for each DB? (yes or no)
- SEPDIR=yes
- # Which day do you want weekly backups? (1 to 7 where 1 is Monday)
- DOWEEKLY=6
- # Choose Compression type. (gzip or bzip2)
- COMP=gzip
- # Compress communications between backup server and MySQL server?
- COMMCOMP=no
- # Additionally keep a copy of the most recent backup in a seperate
- # directory.
- LATEST=no
- # The maximum size of the buffer for client/server communication. e.g. 16MB
- # (maximum is 1GB)
- MAX_ALLOWED_PACKET=
- # For connections to localhost. Sometimes the Unix socket file must be
- # specified.
- SOCKET=
- # Command to run before backups (uncomment to use)
- #PREBACKUP="/etc/mysql-backup-pre"
- # Command run after backups (uncomment to use)
- #POSTBACKUP="/etc/mysql-backup-post"
Add Comment
Please, Sign In to add comment