MySQL Linux backup script

2. #!/bin/sh
4. # MySQL Data backup script
6. #
8. # Use mysqldump--help,get more detail.
10. #
12. Bakdir=/root/back/mysql
14. Logfile=/root/back/mysql/mysqlbak.log
16. Date= ' Date +%y%m%d%h%m%s '
18. echo "" >> $LogFile
20. echo "" >> $LogFile
22. echo "-------------------------------------------" >> $LogFile
24. echo $ (date + "%y-%m-%d%h:%m:%s") >> $LogFile
26. echo "--------------------------" >> $LogFile
28. CD $BakDir
30. dumpfile= $DATE. sql
32. gzdumpfile= $DATE. sql.tar.gz
34. /usr/local/bin/mysqldump-u user-pname--database-h 127.0.0.1 db> $DumpFile
36. echo "Dump done" >> $LogFile
38. Tar czvf $GZDumpFile $DumpFile >> $LogFile 2>&1
40. echo "[$GZDumpFile]backup success!" >> $LogFile
42. Rm-f $DumpFile
44. #cd $BakDir/daily
46. CD $BakDir
48. echo "Backup done!"
50. echo "Please Check $BakDir directory!"
52. echo "Copy it to your local disk or FTP to somewhere!!!"
54. Find $BakDir-ctime +30-exec rm {} \;
56. echo "Delete file over"

MySQL Linux backup script