Back up website files and database

backup-website.sh

#!/bin/bash
#
# Back up website files and database.

backupdir=~/backup
fileid=$(date +%F_%T)
filesource=/var/www/my-website
filetarget=$backupdir/my-website_$fileid.tar.gz
dbsource=my-database-name
dbtarget=$backupdir/my-website_$fileid.sql.tar.gz
defaultsfile=~/.my-database.cnf

mkdir -p $backupdir

echo "Backing up $filesource to $filetarget..."
tar -czvf $filetarget $filesource

echo "Backing up database '$dbsource' to $dbtarget..."
mysqldump --defaults-file=$defaultsfile $dbsource > $dbtarget

echo "Done."