#!/bin/bash
# Author: Carlo Abiog
# Date Created: July 4, 2024
# Date Modified: June 3, 2025
# New dbweb26.ust.edu.ph Daily Backup Script
# March 14, 2025: Added ajels
# March 18, 2025: Added actamanilana
# March 20, 2025: Added pjahs, tomas
# June 3, 2025: Added medicine
# 20150131
# DATE_DIR=$(date +%Y%m%d)
df -H | grep home | awk '{ print $5 " " $1 }' | while read output;
do
  #echo $output
  usep=$(echo $output | awk '{ print $1}' | cut -d'%' -f1  )
  partition=$(echo $output | awk '{ print $2 }' )
  if [ $usep -le 80 ]; then


DATE_NOW=$(date +%m%d%y%H%M)

CREDENTIAL_FILE="/home/credentials.txt"
MCREDENTIALS="--defaults-extra-file=$CREDENTIAL_FILE"

#MYSQL="$(which mysql)"
#MYSQLDUMP="$(which mysqldump)"
#GZIP="$(which gzip)"
#BAK="/${DATE_DIR}"

# Week Number
echo
echo "START TIME: "`date '+%F %r'`
echo
echo "[1/2] backing up source files ... Please Wait"
cp -pr /home/lawjournal /home/lawjournal.dbweb26.$DATE_NOW
cp -pr /home/actamanilana /home/actamanilana.dbweb26.$DATE_NOW
cp -pr /home/ajels /home/ajels.dbweb26.$DATE_NOW
cp -pr /home/pjahs /home/pjahs.dbweb26.$DATE_NOW
cp -pr /home/tomas /home/tomas.dbweb26.$DATE_NOW
#cp -pr /home/medicine /home/medicine.dbweb26.$DATE_NOW
#cp -pr /home/journals /home/journals.$DATE_NOW
echo "[1/2] backing up source files ... Done"
echo
echo "[2/2] backing up database files ... Please Wait"
cd /home
mysqldump $MCREDENTIALS lawjournal > /home/lawjournal.dbweb26.$DATE_NOW.sql
mysqldump $MCREDENTIALS actamanilana> /home/actamanilana.dbweb26.$DATE_NOW.sql
mysqldump $MCREDENTIALS ajels > /home/ajels.dbweb26.$DATE_NOW.sql
mysqldump $MCREDENTIALS pjahs > /home/pjahs.dbweb26.$DATE_NOW.sql
mysqldump $MCREDENTIALS tomas > /home/tomas.dbweb26.$DATE_NOW.sql
#mysqldump $MCREDENTIALS medicine > /home/medicine.dbweb26.$DATE_NOW.sql
#mysqldump $MCREDENTIALS journals > /home/journals.dbweb13.$DATE_NOW.sql
##DBS="$($MYSQL $MCREDENTIALS -Bse 'show databases' | grep -Ev "(Database|information_schema|performance_schema)")"
##for db in $DBS
##do
##  FILE=$BAK/$db.sql.gz
##$MYSQLDUMP $MCREDENTIALS $db | $GZIP -9 > $FILE
##done
echo "[2/2] backing up database files ... Done"
echo
echo "END TIME: "`date '+%F %r'`
echo
HOUR=$(((END - START)/3600))
MIN=$((((END - START) - ((HOUR * 3600)))/60))
echo "BACKUP DURATION: ${HOUR} hours and ${MIN} minutes"
echo



fi
done