Mysql Dump Script ( Updated )

Here is the updated mysql dump script to share that i use on 5 years old servers ( with no downtime ) as a network backup server

#!/bin/bash

##### SETTING #####
MYUSER="root"
MYPWD="******"
DB="mysql **** **** ****"
DIR=$(date +%Y)/$(date +%B)
FAIL=backup_$(date +%d-%m-%Y)
HOST="mysql-local-server"

###################

cd /tmp

##check, repair and optimize before backup
mysqlcheck --auto-repair -m -o -B $DB -u $MYUSER -p$MYPWD -h $HOST
 ##backup now
mysqldump -c -x --add-drop-table --add-locks --database $DB -u $MYUSER -p$MYPWD -h $HOST > $FAIL.sql
if test -d "/home/data-backup/$DIR"
then
        tar -jcf /home/data-backup/$DIR/$FAIL.tgz $FAIL.sql
        #zip -9 -o /home/data-backup/$DIR/$FAIL.zip $FAIL.sql
        #rar -a m5 /home/data-backup/$DIR/$FAIL.rar $FAIL.sql
        rm -f /home/data-backup/latest.tgz
        ln -s /home/data-backup/$DIR/$FAIL.tgz /home/data-backup/latest.tgz
 
# secondary backup to ftp server
#       /skrip/ftpbackend
else
        mkdir -p /home/data-backup/$DIR
        tar -jcf /home/data-backup/$DIR/$FAIL.tgz $FAIL.sql
        rm -f /home/data-backup/latest.tgz
        ln -s /home/data-backup/$DIR/$FAIL.tgz /home/data-backup/latest.tgz


#secondary backup to ftp server
#       /skrip/ftpbackend
fi
rm -f $FAIL