#!/bin/bash
echo "hello"
TODAY=`date +"%d%b%Y"`
echo ${TODAY}
DB_BACKUP_PATH='/var/www/backup_au_server_dbs/db_appleaday'
MYSQL_HOST='localhost'
MYSQL_PORT='1026'
MYSQL_USER='us_aad'
MYSQL_PASSWORD="45b!xkEN5WDF8fQ9fpp"
DATABASE_NAME='db_appleaday'
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}/${DATABASE_NAME}-${TODAY}.sql.gz

if [ $? -eq 0 ]; then
  echo "Database backup successfully completed"
else
  echo "Error found during backup"
fi
#cd ..
php /var/www/university/artisan DBBackupUpload --source=${DB_BACKUP_PATH}/${DATABASE_NAME}-${TODAY}.sql.gz --destination=${DATABASE_NAME}-${TODAY}.sql.gz
echo "file uploaded"