#!/bin/bash
echo "hello"
TODAY=`date +"%d%b%Y"`
echo ${TODAY}
DB_BACKUP_PATH='/var/www/backup/database_dashboard'
MYSQL_HOST='localhost'
MYSQL_PORT='9108'
MYSQL_USER='database_dashboard_user'
MYSQL_PASSWORD="5B*iZw<72i"
DATABASE_NAME='database_dashboard'
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/exam/artisan DBBackupUpload --source=${DB_BACKUP_PATH}/${DATABASE_NAME}-${TODAY}.sql.gz --destination=${DATABASE_NAME}-${TODAY}.sql.gz
echo "file uploaded"