#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 --set-gtid-purged=off --databases alphaonesolution > alphaonesolution.`date +\%Y\%m\%d\%H`.sql
mysqldump -u whmis -p"14pk527X!@#" -h rm-3nsp08e0a25kj2jh3.mysql.rds.aliyuncs.com --set-gtid-purged=off --databases amberconcept > amberconcept.`date +\%Y\%m\%d\%H`.sql
#mysqldump -u whmis -p"14pk527X!@#" -h rm-3nsp08e0a25kj2jh3.mysql.rds.aliyuncs.com --set-gtid-purged=off --databases beyondartcenter > beyondartcenter.`date +\%Y\%m\%d\%H`.sql
mysqldump -u whmis -p"14pk527X!@#" -h rm-3nsp08e0a25kj2jh3.mysql.rds.aliyuncs.com --set-gtid-purged=off --databases breadsecret.com > breadsecret.com.`date +\%Y\%m\%d\%H`.sql
#mysqldump -u whmis -p"14pk527X!@#" -h rm-3nsp08e0a25kj2jh3.mysql.rds.aliyuncs.com --set-gtid-purged=off --databases chualams > chualams.`date +\%Y\%m\%d\%H`.sql
#mysqldump -u whmis -p"14pk527X!@#" -h rm-3nsp08e0a25kj2jh3.mysql.rds.aliyuncs.com --set-gtid-purged=off --databases colorize > colorize.`date +\%Y\%m\%d\%H`.sql
#mysqldump -u whmis -p"14pk527X!@#" -h rm-3nsp08e0a25kj2jh3.mysql.rds.aliyuncs.com --set-gtid-purged=off --databases faq.winghung.com > faq.winghung.com.`date +\%Y\%m\%d\%H`.sql
mysqldump -u whmis -p"14pk527X!@#" -h rm-3nsp08e0a25kj2jh3.mysql.rds.aliyuncs.com --set-gtid-purged=off --databases intranet > intranet.`date +\%Y\%m\%d\%H`.sql
#mysqldump -u whmis -p"14pk527X!@#" -h rm-3nsp08e0a25kj2jh3.mysql.rds.aliyuncs.com --set-gtid-purged=off --databases maskjacket > maskjacket.`date +\%Y\%m\%d\%H`.sql
#mysqldump -u whmis -p"14pk527X!@#" -h rm-3nsp08e0a25kj2jh3.mysql.rds.aliyuncs.com --set-gtid-purged=off --databases photoamberconcept > photoamberconcept.`date +\%Y\%m\%d\%H`.sql
#mysqldump -u whmis -p"14pk527X!@#" -h rm-3nsp08e0a25kj2jh3.mysql.rds.aliyuncs.com --set-gtid-purged=off --databases sparkle > sparkle.`date +\%Y\%m\%d\%H`.sql
#mysqldump -u whmis -p"14pk527X!@#" -h rm-3nsp08e0a25kj2jh3.mysql.rds.aliyuncs.com --set-gtid-purged=off --databases sryipc2 > sryipc2.`date +\%Y\%m\%d\%H`.sql
#mysqldump -u whmis -p"14pk527X!@#" -h rm-3nsp08e0a25kj2jh3.mysql.rds.aliyuncs.com --set-gtid-purged=off --databases test.winghung.com > test.winghung.com.`date +\%Y\%m\%d\%H`.sql
mysqldump -u whmis -p"14pk527X!@#" -h rm-3nsp08e0a25kj2jh3.mysql.rds.aliyuncs.com --set-gtid-purged=off --databases whac > whac.`date +\%Y\%m\%d\%H`.sql
mysqldump -u whmis -p"14pk527X!@#" -h rm-3nsp08e0a25kj2jh3.mysql.rds.aliyuncs.com --set-gtid-purged=off --databases wprint_world > wprint_world.`date +\%Y\%m\%d\%H`.sql
#mysqldump -u whmis -p"14pk527X!@#" -h rm-3nsp08e0a25kj2jh3.mysql.rds.aliyuncs.com --set-gtid-purged=off --databases wpsomonline > wpsomonline.`date +\%Y\%m\%d\%H`.sql

#gzip alphaonesolution.`date +\%Y\%m\%d\%H`.sql
gzip amberconcept.`date +\%Y\%m\%d\%H`.sql
#gzip beyondartcenter.`date +\%Y\%m\%d\%H`.sql
gzip breadsecret.com.`date +\%Y\%m\%d\%H`.sql
#gzip chualams.`date +\%Y\%m\%d\%H`.sql
#gzip colorize.`date +\%Y\%m\%d\%H`.sql
#gzip faq.winghung.com.`date +\%Y\%m\%d\%H`.sql
gzip intranet.`date +\%Y\%m\%d\%H`.sql
#gzip maskjacket.`date +\%Y\%m\%d\%H`.sql
#gzip photoamberconcept.`date +\%Y\%m\%d\%H`.sql
#gzip sparkle.`date +\%Y\%m\%d\%H`.sql
#gzip sryipc2.`date +\%Y\%m\%d\%H`.sql
#gzip test.winghung.com.`date +\%Y\%m\%d\%H`.sql
gzip whac.`date +\%Y\%m\%d\%H`.sql
gzip wprint_world.`date +\%Y\%m\%d\%H`.sql
#gzip wpsomonline.`date +\%Y\%m\%d\%H`.sql

#rm -Rf alphaonesolution.`date --date="7 days ago" +\%Y\%m\%d\%H`.sql.gz
rm -Rf amberconcept.`date --date="27 days ago" +\%Y\%m\%d\%H`.sql.gz
rm -Rf beyondartcenter.`date --date="7 days ago" +\%Y\%m\%d\%H`.sql.gz
rm -Rf breadsecret.com.`date --date="27 days ago" +\%Y\%m\%d\%H`.sql.gz
#rm -Rf chualams.`date --date="7 days ago" +\%Y\%m\%d\%H`.sql.gz
#rm -Rf colorize.`date --date="7 days ago" +\%Y\%m\%d\%H`.sql.gz
#rm -Rf faq.winghung.com.`date --date="7 days ago" +\%Y\%m\%d\%H`.sql.gz
rm -Rf intranet.`date --date="7 days ago" +\%Y\%m\%d\%H`.sql.gz
#rm -Rf maskjacket.`date --date="7 days ago" +\%Y\%m\%d\%H`.sql.gz
#rm -Rf photoamberconcept.`date --date="7 days ago" +\%Y\%m\%d\%H`.sql.gz
#rm -Rf sparkle.`date --date="7 days ago" +\%Y\%m\%d\%H`.sql.gz
#rm -Rf sryipc2.`date --date="7 days ago" +\%Y\%m\%d\%H`.sql.gz
#rm -Rf test.winghung.com.`date --date="27 days ago" +\%Y\%m\%d\%H`.sql.gz
rm -Rf whac.`date --date="27 days ago" +\%Y\%m\%d\%H`.sql.gz
rm -Rf wprint_world.`date --date="27 days ago" +\%Y\%m\%d\%H`.sql.gz
#rm -Rf wpsomonline.`date --date="7 days ago" +\%Y\%m\%d\%H`.sql.gz

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




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