mysql-backup-jhcisdb.sh

# !/bin/sh
    sudo mysqldump --skip-comments --default-character-set=utf8 --routines --lock-tables=false --compatible=no_key_options -u root -p123456 jhcisdb > /var/www/jhcisbackup/jhcisdb-03301.$(date -d "+0 day" "+%Y-%m-%d").sql

cd /var/www/jhcisbackup/
FILE=jhcisdb-03301.$(date -d "+0 day" "+%Y-%m-%d").sql
if [ -f "$FILE" ]; then
     sudo zip -r jhcisdb-03301.$(date -d "+0 day" "+%Y-%m-%d").zip "$FILE"
fi

cd /var/www/jhcisbackup/
FILE=jhcisdb-03301.$(date -d "+0 day" "+%Y-%m-%d").zip
if [ -f "$FILE" ]; then
     sudo rm -f /var/www/jhcisbackup/jhcisdb-03301.$(date -d "-0 day" "+%Y-%m-%d").sql
     sudo rm -f /var/www/jhcisbackup/jhcisdb-03301.$(date -d "-73 day" "+%Y-%m-%d").zip
     sudo rm -f /var/www/jhcisbackup/jhcisdb-03301.$(date -d "-73 day" "+%Y-%m-%d").zip
fi