Cacher is the code snippet organizer for pro developers

#!/bin/bash

#
# Script file for dumping MySQL databases for backup
# Gzip included
#
# Niko Heikkilä, 2010 - 2011
#


NOW=$(date +"%Y-%m-%d")
MOD=700
db=databasename
MUSER="admin"
MPASS="secret"
MHOST="databasehost"

MYSQL="$(which mysql)"
MYSQLDUMP="$(which mysqldump)"
GZIP="$(which gzip)"
CHMOD="$(which chmod)"

FILE=$HOME/siilo/mysql-$NOW.gz

$MYSQLDUMP -u $MUSER -h $MHOST -p$MPASS --add-drop-table $db | $GZIP -f -9 > $FILE
$CHMOD $MOD $FILE