##DATE=`date +%Y%m%d_%H%M%S`; mysqldump -ubeyon150_live -p[C4d;,tRmw}S beyon150_live | gzip  > /home/beyon150/ewd_backups/db_backup/live_db-$DATE.sql.gz

export PATH=/bin:/usr/bin:/usr/local/bin
TODAY=`date +"%d%b%Y"`
TIME=`date +"%d%b%Y_%H%M%S"`
 
################################################################
################## Update below values  ########################


 
DB_BACKUP_PATH='/home/a0004771/public_html/ewd_backups/db_backup'
MYSQL_HOST='localhost'
MYSQL_PORT='3306'
MYSQL_USER='a0004771_user22'
MYSQL_PASSWORD='s@xMP}^%H4xZPl{b}5'
DATABASE_NAME='a0004771_vic2022'
BACKUP_RETAIN_DAYS=30   ## Number of days to keep local backup copy
 
#################################################################
 
mkdir -p ${DB_BACKUP_PATH}/${TODAY}
echo "Backup started for database - ${DATABASE_NAME}"
 
 
mysqldump -h ${MYSQL_HOST} \
   -P ${MYSQL_PORT} \
   -u ${MYSQL_USER} \
   -p${MYSQL_PASSWORD} \
   ${DATABASE_NAME} | gzip > ${DB_BACKUP_PATH}/${TODAY}/${DATABASE_NAME}-${TIME}.sql.gz
 
if [ $? -eq 0 ]; then
  echo "Database backup successfully completed"
  ##curl -T ${DB_BACKUP_PATH}/${TODAY}/${DATABASE_NAME}-${TODAY}.sql.gz ftp://mydemoview.com/ewd/sense/db/backups/ --user dfccapp@mydemoview.com:h==reCz8[[@]
  ##echo "Ftp backup successfully completed"
  
else
  echo "Error found during backup"
  exit 1
fi

 
 
##### Remove backups older than {BACKUP_RETAIN_DAYS} days  #####
 
DBDELDATE=`date +"%d%b%Y" --date="${BACKUP_RETAIN_DAYS} days ago"`
 
if [ ! -z ${DB_BACKUP_PATH} ]; then
      cd ${DB_BACKUP_PATH}
      if [ ! -z ${DBDELDATE} ] && [ -d ${DBDELDATE} ]; then
            rm -rf ${DBDELDATE}
      fi
fi