#!/usr/bin/bash

date="`eval date +%Y%m%d`";
mysqluser="mysqluser"
mysqlpass="mysqlpassword"
mysqldb="blogdatabase"
backupsource="/home/user/public_html/"
backupdest="/home/user/backups/"

echo "creating database backup"
mysqldump -q -e -h localhost -u ${mysqluser} -p${mysqlpass} ${mysqldb} | gzip - > ~/${backupdest}${date}_db-backup.sql.gz
echo "done"
echo "creating file system backup"
cd ~/${backupsource}
tar cf - . | gzip - > ~/${backupdest}${date}_files.tar.gz
echo "done"
echo "wordpress backup complete"