#!/bin/bash
#
# To restore to another unicode databaase from this backup
# Please add SET NAMES ‘utf8′; to the top of the SQL backup file.
# Tune SET CHARACTER_SET_XXX = ‘XXX’; yourself pls.
#
DATE=`date +%Y%m%d`
HOST=db.samuelchen.net
USER=user
PASS=123456
DB=database
EMAIL=”email@yourhost.com”
DB_FILE=”$DB-$DATE”
SITE_FILE=”samuelchen-$DATE.tar.gz”
SITE_PATH=samuelchen.net/
TIL=”Explore.Dream.Discover.Database-Dump-AutoBackup”

# clean cache
rm /home/yourhome/blog/wp-content/cache/* -r >/dev/null

# dump & pack database
mysqldump –default-character-set=latin1 –set-charset=utf8 –skip-opt -u$USER -p$PASS -h $HOST $DB > $DB_FILE.sql
gzip $DB_FILE.sql -f

# pack whole site
tar zvcf $SITE_FILE $SITE_PATH >/dev/null

# send email
mv $DB_FILE.sql.gz $DB_FILE.gz | mutt $EMAIL -s $TIL -a $DB_FILE.gz -a $SITE_FILE -i backup.sh

# clean & keep archives
mv $DB_FILE.gz /home/yourhome/backup/
mv $SITE_FILE /home/yourhome/backup/