# !/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/MEGAsync/jhcisbackup/jhcisdb-03306-$(date -d "+0 day" "+%Y.%m.%d").sql
cd /home/jhcis/MEGAsync/jhcisbackup/
FILE=jhcisdb-03306-$(date -d "+0 day" "+%Y.%m.%d").sql
if [ -f "$FILE" ]; then
sudo zip -r jhcisdb-03306-$(date -d "+0 day" "+%Y.%m.%d").zip "$FILE"
fi
cd /home/jhcis/MEGAsync/jhcisbackup/
FILE=jhcisdb-03306-$(date -d "+0 day" "+%Y.%m.%d").zip
if [ -f "$FILE" ]; then
sudo rm -f /home/jhcis/MEGAsync/jhcisbackup/jhcisdb-03306-$(date -d "+0 day" "+%Y.%m.%d").sql
sudo rm -f /home/jhcis/MEGAsync/jhcisbackup/jhcisdb-03306-$(date -d "-63 day" "+%Y.%m.%d").zip
sudo rm -f /home/jhcis/MEGAsync/jhcisbackup/jhcisdb-03306-$(date -d "-64day" "+%Y.%m.%d").zip
sudo rm -f /home/jhcis/MEGAsync/jhcisbackup/jhcisdb-03306-$(date -d "-65 day" "+%Y.%m.%d").zip
fi
