#!/bin/bash
# This script runs as a nightly cron job to back a MySQL database to an email 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=your@email.com

# Local directory where we'll be doing work and keeping copies of all archived files
BACKUPDIR=/home/account/backups

# MySQL username and password
MYSQLUSER=account_user

MYSQLPASS=the_password_for_the_database_user

# 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
rm $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

#!/usr/local/bin/php -q
<?php