Backup MySQL to Email

yamadora의 이미지

#!/bin/bash
# This script runs as a nightly cron job to back a MySQL database to a Gmail account
	# Prints date of the format MM/DD/YY
TODAY1="date +%D”
# Prints date of the format MMDDYYYY
TODAY2="date +%m%d%Y”
# The email address to which we’re sending backups
ADDRESS="someone@gmail.com”
# Local directory where we’ll be doing work and keeping copies of all archived files
BACKUPDIR="/root/backup”
# MySQL username and password
MYSQLUSER="root”
MYSQLPASS="f00b@R”
# MySQL database to backup (or –all-databases to backup everything)
DATABASE="–all-databases”
$ Name of backup file (used for plaintext and gzipped files)
FILENAME="mysql_backup”
	# Change to the backup directory (so absolute directories aren’t included in the archive)
cd $BACKUPDIR
	# Dump the MySQL databases to a plaintext file
mysqldump -u $MYSQLUSER -p $MYSQLPASS $DATABASE > $FILENAME_$TODAY2
	# Package (tar) and compress (gzip) the plaintext MySQL dump
# Append the date (MMDDYYYY) to the filename
tar czf $FILENAME_$TODAY2.tar.gz $FILENAME_$TODAY2
	# Mail the resulting archive to our Gmail account
# Body of email is the output from the date command at the exact time the cron job runs
# Subject is “$FILENAME MM/DD/YY”
date | mutt -s “$FILENAME ($TODAY1)” -a $FILENAME_$TODAY2.tar.gz $ADDRESS

간단히 만들었습니다.
틀린 부분 있으면 말씀해 주세요...