Linux system MySQL automatic backup and use FTP upload method _linux Shell

Copy Code code as follows:

#!/bin/bash
#ftp设置
Host=ftp_ip
Username=ftp_user
passwd=ftp_passwd
#备份mysql并导出到文件
Mysqldump-u user--password= User password database name > $ (Date +%y%m%d)-database name. sql
#压缩备份文件
TAR-ZCVF $ (date +%y%m%d) MySQL database name. tar.gz $ (Date +%y%m%d) *
#上传到ftp
echo "Open $Host
User $Username $Passwd
Bin
cd/hzg/
Prompt off
Mput $ (date +%y%m%d) MySQL database name. tar.gz
printf "n"
Close
Bye "|ftp-i-n
#删除旧的备份文件
RM-RF $ (Date +%y%m%d)-database name. SQL $ (date +%y%m%d) MySQL database name. tar.gz
#rm-RF $ (date +%y%m%d) *
RM-RF $ (Date +%y%m%d) *