Shell script to backup MySql database.

mysql_db_backup.sh

#!/bin/bash
# Shell script to backup MySql database.
# Usage: dbbackup db_name / dbbackup "db_name1 db_name2 db_name3"
# --------------------------------------------------------------------

MyUSER="user"               # USERNAME
MyPASS="pwd"                # PASSWORD
MyHOST="localhost"          # HOSTNAME

# Backup Dest directory, change this if you have someother location
DEST="/backup"

# Main directory where backup will be stored
MBDS="$DEST/mysql"

# Linux bin paths, change this if it can not be autodetected via which command
DUMP="$(which mysqldump)"
GZIP="$(which gzip)"

# Get data in yyyy-mm-dd format
DATE="$(date +"%Y%m%d%H%M")"

[ ! -d $MBDS ] && mkdir -p $MBDS || :

# Only root can access it!
chown 0.0 -R $DEST
chmod 0600 $DEST

for db in $1
do
    FILE="$MBDS/$db.$DATE.sql.gz"
    # connect to mysql using mysqldump for select mysql database
    # and pipe it out to gz file in backup dir :-)
    $DUMP -u $MyUSER -h $MyHOST -p$MyPASS $db | $GZIP -9 > $FILE
done