Simple script to backup some directory and MySQL database.

backup.sh

#! /bin/bash

date=$(date +"%y%m%d-%H%M%S")
dir="~/foo/bar/" # with trailing slash
project="foo.bar"
db="foo"
db_user="bar"

echo "Creating  archive ..."
tar -czf ${date}_${project}.tgz ${dir}${project} >/dev/null 2>&1
echo "Created archive of "${dir}${project}

echo "Creating database dump ..."
mysqldump --single-transaction -u${db_user} -p ${db} > ${date}_${project}.sql
gzip ${date}_${project}.sql
echo "Created database dump of "${db}