Drupal files and database backup script

backup.sh

#!/bin/sh
#Set information specific to your site
webroot="/srv/www/example.com"
db_user="example.com"
db_password="XXXXXXXXXXXXXXXX"
db_name="example.com"

#Set the date and name for the backup files
date=`date '+%A'`

#Dump the mysql database

mysqldump -u $db_user --password="$db_password" $db_name > $webroot/backups/db_backup_$date.sql

#Backup Site
env GZIP=-9 tar -czpf backups/site_backup_$date.tar.gz public_html/