Mysql automatic backup script

#! / bin / bash
# This is a ShellScript For Auto DB Backup
# Powered by aspbiz

# Setting
# Set the database name, database login names, passwords, backup path, log path, data file location, as well as backup
# By default, the backup is tar, can also be mysqldump, mysqldotcopy
# By default, with the root (empty) log mysql database backup to / root / dbxxxxx.tgz
DBName = mysql
DBUser = root
DBPasswd =
BackupPath = / root /
LogFile = / root / db.log
DBPath = / var / lib / mysql /
# BackupMethod = mysqldump
# BackupMethod = mysqlhotcopy
# BackupMethod = tar
# Setting End

NewFile = "$ BackupPath" db $ (date +% y% m% d). Tgz
DumpFile = "$ BackupPath" db $ (date +% y% m% d)
OldFile = "$ BackupPath" db $ (date +% y% m% d - date = '5 days ago '). Tgz

echo "-------------------------------------------">;>; $ LogFile
echo $ (date + "% y-% m-% d% H:% M:% S")>;>; $ LogFile
echo "--------------------------">;>; $ LogFile
# Delete Old File
if [-f $ OldFile]
then
rm-f $ OldFile>;>; $ LogFile 2>; & 1
echo "[$ OldFile] Delete Old File Success!">;>; $ LogFile
else
echo "[$ OldFile] No Old Backup File!">;>; $ LogFile
fi

if [-f $ NewFile]
then
echo "[$ NewFile] The Backup File is exists, Can't Backup!">;>; $ LogFile
else
case $ BackupMethod in
mysqldump)
if [-z $ DBPasswd]
then
mysqldump-u $ DBUser - opt $ DBName>; $ DumpFile
else
mysqldump-u $ DBUser-p $ DBPasswd - opt $ DBName>; $ DumpFile
fi
tar czvf $ NewFile $ DumpFile>;>; $ LogFile 2>; & 1
echo "[$ NewFile] Backup Success!">;>; $ LogFile
rm-rf $ DumpFile
;;
mysqlhotcopy)
rm-rf $ DumpFile
mkdir $ DumpFile
if [-z $ DBPasswd]
then
mysqlhotcopy-u $ DBUser $ DBName $ DumpFile>;>; $ LogFile 2>; & 1
else
mysqlhotcopy-u $ DBUser-p $ DBPasswd $ DBName $ DumpFile >;>;$ LogFile 2>; & 1
fi
tar czvf $ NewFile $ DumpFile>;>; $ LogFile 2>; & 1
echo "[$ NewFile] Backup Success!">;>; $ LogFile
rm-rf $ DumpFile
;;
*)
/ etc / init.d / mysqld stop>; / dev / null 2>; & 1
tar czvf $ NewFile $ DBPath $ DBName>;>; $ LogFile 2>; & 1
/ etc / init.d / mysqld start>; / dev / null 2>; & 1
echo "[$ NewFile] Backup Success!">;>; $ LogFile
;;
esac
fi

echo "-------------------------------------------">;>; $ LogFile