# !/bin/sh
/usr/local/mysql/bin/mysqldump --skip-comments --default-character-set=utf8 --routines --lock-tables=false --compatible=no_key_options -u root -pnhc03301 jhcisdb > /home/jhcis/Desktop/jhcisdb-backup-tmp/jhcisdb-03301.$(date -d "+0 day" "+%Y-%m-%d").sql
cd /home/jhcis/Desktop/jhcisdb-backup-tmp/
FILE1=jhcisdb-03301.$(date -d "+0 day" "+%Y-%m-%d").sql
if [ -f "$FILE1" ]; then
sudo zip -r jhcisdb-03301.$(date -d "+0 day" "+%Y-%m-%d").zip "$FILE1"
fi
FILE2=jhcisdb-03301.$(date -d "+0 day" "+%Y-%m-%d").zip
sudo cp /home/jhcis/Desktop/jhcisdb-backup-tmp/$FILE2 /home/jhcis/Google\ Drive/jhcisbackup/
cd /home/jhcis/Google\ Drive/jhcisbackup/
if [ -f "$FILE2" ]; then
sudo rm -f /home/jhcis/Google\ Drive/jhcisbackup/jhcisdb-03301.$(date -d "-0 day" "+%Y-%m-%d").sql
sudo rm -f /home/jhcis/Google\ Drive/jhcisbackup/jhcisdb-03301.$(date -d "-32 day" "+%Y-%m-%d").zip
sudo rm -f /home/jhcis/Google\ Drive/jhcisbackup/jhcisdb-03301.$(date -d "-33 day" "+%Y-%m-%d").zip
fi
