Backup MySQL to Email
글쓴이: yamadora / 작성시간: 수, 2005/01/19 - 12:22오후
#!/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
간단히 만들었습니다.
틀린 부분 있으면 말씀해 주세요...
Forums:


댓글 달기