我的MySQL备份脚本

#!/bin/bash
date=`date +%Y%m%d`
backDb=$date.sql
backFile=$date.tar.gz
backHost=135.26.25.36 #FTP服务器IP地址
backUser=ftp                #FTP服务器用户名
backPwd= password       #FTP密码

/usr/local/mysql/bin/mysqldump dbname -udbuser -pdbpassword > /home/backup/$backDb
echo -e "DB Backup Done!/n"

tar -zcvf /home/phpeye/$backFile  /websites/phpeye/
echo -e "File Backup Done!/n"

ftp -n $backHost<<!
user $backUser $backPwd
passive
put /home/backup/$backDb  phpeyebackup/$backDb
bye
!

ftp -n<<!
open $backHost 21
user $backUser $backPwd
port
prompt
put /home/phpeye/$backFile  phpeyebackup
bye
!

rm -f /home/web_happy/phpeye/$backDb
echo -e "Backup Done!/n"