#!/bin/bash
#Ftp Informaition
Host=120.25.159.196
Username=Administrator
Passwd=Qilinof841321
#start mysqldump back
/alidata/server/mysql/bin/mysqldump -uroot -p6a433af185 -R paiauto > $(date +%Y%m%d)-paiauto.sql
#start tar
tar -zcvf $(date +%Y%m%d)mysql.tar.gz ./$(date +%Y%m%d)*
#start ftp
echo "open $Host
user $Username $Passwd
bin
cd ./mysqlback
prompt off
mput $(date +%Y%m%d)mysql.tar.gz
printf "\n"
close
bye"|ftp -i -n
#del the old file
rm -rf $(date +%Y%m%d)-paiauto.sql
#rm -rf $(date +%Y%m%d)*
#Ftp Informaition
Host=120.25.159.196
Username=Administrator
Passwd=Qilinof841321
#start mysqldump back
/alidata/server/mysql/bin/mysqldump -uroot -p6a433af185 -R paiauto > $(date +%Y%m%d)-paiauto.sql
#start tar
tar -zcvf $(date +%Y%m%d)mysql.tar.gz ./$(date +%Y%m%d)*
#start ftp
echo "open $Host
user $Username $Passwd
bin
cd ./mysqlback
prompt off
mput $(date +%Y%m%d)mysql.tar.gz
printf "\n"
close
bye"|ftp -i -n
#del the old file
rm -rf $(date +%Y%m%d)-paiauto.sql
#rm -rf $(date +%Y%m%d)*