#By Cathy - 20150825
#---------- backup+gzip MYSQL database and upload to FTP ----------

cd /var/www/html/ossfs/backup/wordpress

mysqldump -u whmis -p"14pk527X!@#" -h rm-3nsp08e0a25kj2jh3.mysql.rds.aliyuncs.com --databases sparkle > sparkle.`date +\%Y\%m\%d\%H`.sql
mysqldump -u whmis -p"14pk527X!@#" -h rm-3nsp08e0a25kj2jh3.mysql.rds.aliyuncs.com --databases beyondartcenter > beyondartcenter.`date +\%Y\%m\%d\%H`.sql
mysqldump -u whmis -p"14pk527X!@#" -h rm-3nsp08e0a25kj2jh3.mysql.rds.aliyuncs.com --databases wpsomonline > wpsomonline.`date +\%Y\%m\%d\%H`.sql
mysqldump -u whmis -p"14pk527X!@#" -h rm-3nsp08e0a25kj2jh3.mysql.rds.aliyuncs.com --databases maskjacket > maskjacket.`date +\%Y\%m\%d\%H`.sql
mysqldump -u whmis -p"14pk527X!@#" -h rm-3nsp08e0a25kj2jh3.mysql.rds.aliyuncs.com --databases alphaonesolution > alphaonesolution.`date +\%Y\%m\%d\%H`.sql
mysqldump -u whmis -p"14pk527X!@#" -h rm-3nsp08e0a25kj2jh3.mysql.rds.aliyuncs.com --databases chualams > chualams.`date +\%Y\%m\%d\%H`.sql
mysqldump -u whmis -p"14pk527X!@#" -h rm-3nsp08e0a25kj2jh3.mysql.rds.aliyuncs.com --databases photoamberconcept > photoamberconcept.`date +\%Y\%m\%d\%H`.sql
mysqldump -u whmis -p"14pk527X!@#" -h rm-3nsp08e0a25kj2jh3.mysql.rds.aliyuncs.com --databases 	amberconcept > 	amberconcept.`date +\%Y\%m\%d\%H`.sql
mysqldump -u whmis -p"14pk527X!@#" -h rm-3nsp08e0a25kj2jh3.mysql.rds.aliyuncs.com --databases 	breadsecret.com > 	breadsecret.com.`date +\%Y\%m\%d\%H`.sql

gzip sparkle.`date +\%Y\%m\%d\%H`.sql
gzip beyondartcenter.`date +\%Y\%m\%d\%H`.sql
gzip wpsomonline.`date +\%Y\%m\%d\%H`.sql
gzip maskjacket.`date +\%Y\%m\%d\%H`.sql
gzip alphaonesolution.`date +\%Y\%m\%d\%H`.sql
gzip chualams.`date +\%Y\%m\%d\%H`.sql
gzip photoamberconcept.`date +\%Y\%m\%d\%H`.sql
gzip amberconcept.`date +\%Y\%m\%d\%H`.sql
gzip breadsecret.com.`date +\%Y\%m\%d\%H`.sql

rm -Rf sryipc2.`date --date="23 days ago" +\%Y\%m\%d\%H`.sql.gz
rm -Rf beyondartcenter.`date --date="23 days ago" +\%Y\%m\%d\%H`.sql.gz
rm -Rf wpsomonline.`date --date="23 days ago" +\%Y\%m\%d\%H`.sql.gz
rm -Rf maskjacket.`date --date="23 days ago" +\%Y\%m\%d\%H`.sql.gz
rm -Rf alphaonesolution.`date --date="23 days ago" +\%Y\%m\%d\%H`.sql.gz
rm -Rf chualams.`date --date="23 days ago" +\%Y\%m\%d\%H`.sql.gz
rm -Rf photoamberconcept.`date --date="23 days ago" +\%Y\%m\%d\%H`.sql.gz
rm -Rf amberconcept.`date --date="23 days ago" +\%Y\%m\%d\%H`.sql.gz
rm -Rf breadsecret.com.`date --date="23 days ago" +\%Y\%m\%d\%H`.sql.gz

find /var/www/html/ossfs/backup/wordpress -mtime +23 -type f -delete




#---------- Upload backup files to ftp.winghung.com [ID:linuxbackup] ----------