Backup mysql database script

From Wiki

#!/bin/bash
# Created by Bryan Le Gear - Skynet 2005/10/12
#
# This script must be run by dbadmin
# and this user must have the root password
# configured in ~/.my.cnf
#


COMPRESS=gzip
MYSQLDUMP=mysqldump
MYSQLDUMP_ARGS="-u root -p --lock-tables=false --all-databases"
CURRDATE=`date +%d-%m-%Y`
BACKUPDIR=/home/backup
OUTFILE=$BACKUPDIR/mysqlbackup_$CURRDATE.sql.gz

echo 
echo "Backing up to:     " $OUTFILE
echo "Compressing using: " $COMPRESS
$MYSQLDUMP $MYSQLDUMP_ARGS | $COMPRESS > $OUTFILE 

echo "Chmoding to:         400"
chmod 400 $OUTFILE
Retrieved from "http://wiki.kartbuilding.net/index.php/Backup_mysql_database_script"