#!/bin/bash

cd ~/mysub.example.com

#/************************ EDIT VARIABLES ************************/
projectName=mysub_demo
backupDir=/home/username/_backups
#/************************ //EDIT VARIABLES **********************/

fileName=$projectName-$(date +"%Y-%m-%d-%H%M")
host=$(grep DB_HOST "wp-config.php" |cut -d "'" -f 4)
username=$(grep DB_USER "wp-config.php" | cut -d "'" -f 4)
password=$(grep DB_PASSWORD "wp-config.php" | cut -d "'" -f 4)
dbName=$(grep DB_NAME "wp-config.php" |cut -d "'" -f 4)

# Initial setup
TODAY=$(date)
echo "----------------------------------------------------
Date: $TODAY
Host: mysub.example.com automated backup"

# Backup DB
echo "----------------------------------------------------"
echo "Dumping MySQL..."
mysqldump -h "$host" -u "$username" -p"$password" "$dbName" | gzip > $fileName.sql.gz
echo "Done!"

# Backup files
echo "----------------------------------------------------"
echo "Archiving Files..."
tar -zcf $fileName.tar.gz * .htaccess
echo "Done!"
echo "----------------------------------------------------"
echo "Cleaning..."
rm -f $fileName.sql.gz
echo "Done!"

# Move to backup directory
echo "----------------------------------------------------"
mkdir -p $backupDir;
echo "Moving file to backup dir..."
mv $fileName.tar.gz $backupDir

# Keep last 30 Backups
echo "----------------------------------------------------"
echo "Removing old backups..."
find $backupDir -type f -mtime +30 -exec rm {} ;
echo "Backup of Complete!"