Backup mysql lotation of 30 days

mysql_backup

#!/bin/sh
#
# Name: mysql_backup
#
# Purpose:
#    Backup mysql lotation of 30 days
#     
# Usage:
#    mysql_backup {db_user} {db_password} {db_host} {db_name dump_dir}
########################################################
echo `date`" [$$] mysql_backup started."

DATE=$(date +'%Y%m%d%H%M%S')
CMDNAME=`basename $0`

if [ $# -ne 5 ]; then
    echo "Usage: $CMDNAME {db_user} {db_password} {db_host} {db_name dump_dir}" 1>&2
    exit 1;
fi

USER="-u $1"
PASSWORD="-p$2"
if [ $3 != "localhost" ]; then
  DB_HOST="-h $3"
else
  DB_HOST=""
fi
DB_NAME=$4
DUMP_DIR=$5

BACKUP_FILE=${DUMP_DIR}"/"${DB_NAME}_`date +'%Y%m%d'`.sql
if [ -f $BACKUP_FILE.gz ];then
    rm -f $BACKUP_FILE.gz
fi    
mysqldump $USER $PASSWORD $HOST $DB_NAME > $BACKUP_FILE

gzip $BACKUP_FILE

find $DUMP_DIR -mtime +30 -type f -exec rm -f {} \;

echo `date`" [$$] mysql_backup finished."

exit 0