Mysqldump backup script

mysqldump cron script

#!/bin/bash

NOW=`date +%d-%b`

USER="root"
PASSWORD="lolwat"
OUTPUTDIR="/backup/databases/$NOW"
MYSQLDUMP="mysqldump"
MYSQL="mysql"

mkdir $OUTPUTDIR

# clean up any old backups - save space
#rm "OUTPUTDIR/*bak" > /dev/null 2>&1

# get a list of databases
databases=`$MYSQL --user=$USER --password=$PASSWORD -e "SHOW DATABASES;" | tr -d "| " | grep -v Database`

# dump each database in turn
for db in $databases; do
    echo $db
    $MYSQLDUMP --force --opt --user=$USER --password=$PASSWORD --databases $db > "$OUTPUTDIR/$db.sql"
done