利用godaddy免费空间对VPS进行数据备份

#!/bin/bash
### MySQL Server Login Info ###
MUSER="username"
MPASS="password"
MHOST="localhost"
MYSQL="$(which mysql)"
MYSQLDUMP="$(which mysqldump)"
BAK="/home/yourname/backup/mysql"
GZIP="$(which gzip)"
### FTP SERVER Login info ###
FTPU="ftp username"
FTPP="ftp password"
FTPS="ftp server"
NOW=$(date +"%d-%m-%Y")

[ ! -d $BAK ] && mkdir -p $BAK || /bin/rm -f $BAK/*

DBS="$($MYSQL -u $MUSER -h $MHOST -p$MPASS -Bse 'show databases')"
for db in $DBS
do
 FILE=$BAK/$db.$NOW-$(date +"%T").gz
 $MYSQLDUMP -u $MUSER -h $MHOST -p$MPASS $db | $GZIP -9 > $FILE
done

lftp -u $FTPU,$FTPP -e "mkdir /db-backup/$NOW;cd /db-backup/$NOW; mput /home/yourname/backup/mysql/*; quit" $FTPS

find /home/yourname/backup/mysql -ctime +4 -exec rm {} \;