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

cd /home/backup

mysqldump -u root -p"14pk527X!" --databases sparkle > sparkle.`date +\%Y\%m\%d\%H`.sql
mysqldump -u root -p"14pk527X!" --databases beyondartcenter > beyondartcenter.`date +\%Y\%m\%d\%H`.sql
mysqldump -u root -p"14pk527X!" --databases wpsomonline > wpsomonline.`date +\%Y\%m\%d\%H`.sql
mysqldump -u root -p"14pk527X!" --databases maskjacket > maskjacket.`date +\%Y\%m\%d\%H`.sql
mysqldump -u root -p"14pk527X!" --databases alphaonesolution > alphaonesolution.`date +\%Y\%m\%d\%H`.sql
mysqldump -u root -p"14pk527X!" --databases chualams > chualams.`date +\%Y\%m\%d\%H`.sql
mysqldump -u root -p"14pk527X!" --databases peterpennamber > peterpennamber.`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 peterpennamber.`date +\%Y\%m\%d\%H`.sql

rm -Rf sryipc2.`date --date="3 days ago" +\%Y\%m\%d\%H`.sql.gz
rm -Rf beyondartcenter.`date --date="3 days ago" +\%Y\%m\%d\%H`.sql.gz
rm -Rf wpsomonline.`date --date="3 days ago" +\%Y\%m\%d\%H`.sql.gz
rm -Rf maskjacket.`date --date="3 days ago" +\%Y\%m\%d\%H`.sql.gz
rm -Rf alphaonesolution.`date --date="3 days ago" +\%Y\%m\%d\%H`.sql.gz
rm -Rf chualams.`date --date="3 days ago" +\%Y\%m\%d\%H`.sql.gz
rm -Rf peterpennamber.`date --date="3 days ago" +\%Y\%m\%d\%H`.sql.gz

find /home/backup -mtime +2 -type f -delete




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