Mysql database backup script

#! /Bin/bashDBName = myqlDBUser = rootdbpassswd = 123456 BackupPath =/root/LogFile =/root/db. logDBPath =/var/lib/mysql/NewFile = & quot; $ BackupPath & quot; db $ (date + % Y % m % d ). tgzDump

#! /Bin/bash

DBName = myql
DBUser = root
DBPasswd = 123456
BackupPath =/root/
LogFile =/root/db. log
DBPath =/var/lib/mysql/

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

If [-f $ OldFile]
Then
 Rm-rf $ 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-cvzf $ 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-cvzf $ NewFile $ DumpFile >>$ LogFile 2> & 1
 Echo "[$ NewFile] Backup Success! ">>> $ LogFile
 Rm-rf $ DumpFile
 ;;
 *)
 /Etc/init. d/mysqld stop>/dev/null 2> & 1
 Tar cvzf $ NewFile $ DBPath $ DBName >>$ LogFile 2> & 1
 /Etc/init. d/mysqld start>/dev/null 2> & 1
 Echo "[$ NewFile] Backup Success! ">>> $ LogFile
 ;;
 Esac
Fi

Echo "-----------------------------------------"> $ LogFile