#! /bin/bash

BFF_DB_NAME="egov_bff"
SUPPORT_DB_NAME="egov_support"
DPASS_DB_NAME="egov.ms_dpass"


DB_USER="root"
DB_PASS="NkttexONF3dnji0pVIKG"
BACKUP_DIR="/home/ituser/backups/databases"
DATE=$(date +"%Y_%m_%d_%H_%M_%S")

echo "--------------------"
echo "Backup BFF Database"
echo "--------------------"
sudo mysqldump --user=$DB_USER --password=$DB_PASS --no-tablespaces $BFF_DB_NAME > $BACKUP_DIR/$BFF_DB_NAME-$DATE.sql
sudo gzip $BACKUP_DIR/$BFF_DB_NAME-$DATE.sql

echo "--------------------"
echo "Backup Support Database"
echo "--------------------"
sudo mysqldump --user=$DB_USER --password=$DB_PASS --no-tablespaces $SUPPORT_DB_NAME > $BACKUP_DIR/$SUPPORT_DB_NAME-$DATE.sql
sudo gzip $BACKUP_DIR/$SUPPORT_DB_NAME-$DATE.sql

echo "--------------------"
echo "Backup Dpass Database"
echo "--------------------"
sudo mysqldump --user=$DB_USER --password=$DB_PASS --no-tablespaces $DPASS_DB_NAME > $BACKUP_DIR/$DPASS_DB_NAME-$DATE.sql
sudo gzip $BACKUP_DIR/$DPASS_DB_NAME-$DATE.sql

echo "----------------------"
echo "Delete Older Databases"
echo "----------------------"
find $BACKUP_DIR -type f -name "*.gz" -mtime +7 -delete