# !/bin/sh
sudo mysqldump --default-character-set=utf8 --allow-keywords --add-drop-table --compatible=mysql40 --no-set-names --lock-tables=false --set-charset=true --skip-disable-keys --skip-add-locks -u root -p123456 jhcisdb > /home/jhcis/Dropbox/jhcisbackup/jhcisdb03309-$(date -d "+0 day" "+%Y.%m.%d").sql
cd /home/jhcis/Dropbox/jhcisbackup/
FILE=jhcisdb03309-$(date -d "+0 day" "+%Y.%m.%d").sql
if [ -f "$FILE" ]; then
sudo zip -r jhcisdb03309-$(date -d "+0 day" "+%Y.%m.%d").zip "$FILE"
fi
cd /home/jhcis/Dropbox/jhcisbackup/
FILE=jhcisdb03309-$(date -d "+0 day" "+%Y.%m.%d").zip
if [ -f "$FILE" ]; then
sudo rm -f /home/jhcis/Dropbox/jhcisbackup/jhcisdb03309-$(date -d "+0 day" "+%Y.%m.%d").sql
sudo rm -f /home/jhcis/Dropbox/jhcisbackup/jhcisdb03309-$(date -d "-8 day" "+%Y.%m.%d").zip
sudo rm -f /home/jhcis/Dropbox/jhcisbackup/jhcisdb03309-$(date -d "-9 day" "+%Y.%m.%d").zip
sudo rm -f /home/jhcis/Dropbox/jhcisbackup/jhcisdb03309-$(date -d "-10 day" "+%Y.%m.%d").zip
fi
