• - - #!/bin/bash
  • - FTP_USER=xxxxx #ftp Username
  • FTP_PASS=123456789 #ftp Password
  • FTP_IP=xxx.online.net #ftp Server
  • FTP_backup=mydb #ftp dir
  • mysql_DATA=/usr/local/mysql/var #Mysql backup dir
  • BakFilePwd=d5qs0APWrn590S3H
  • - # Define DB file name
  • DataBakName=DB_$(date +"%Y%m%d").zip
  • OldData=DB_$(date -d -5day +"%Y%m%d").zip
  • - # Delete 3 days ago datas
  • rm -rf /home/backup/DB_$(date -d -3day +"%Y%m%d").zip
  • - cd /home/backup
  • - # Stop Mysql
  • service mysql stop
  • - # Tar Data
  • cd $mysql_DATA
  • zip -q -r -P $BakFilePwd /home/backup/$DataBakName ./* #这样压缩有错吗?
  • - # Start Mysql
  • service mysql start
  • - # Upload to FTP Server
  • cd /home/backup
  • ftp -v -n $FTP_IP 复制代码