#!/bin/bash

#remove old files
rm $HOME/html/_db_backups/*.gz

#section for database backup
NOWDATE=`date +%m%d%y` # Sets the date variable format for zipped file
/usr/bin/mysqldump -h HOST -u USER -pPASSWORD DATABASE  | gzip > $HOME/html/_db_backups/db_backup_$NOWDATE.sql.gz # !!!! DONT FORGET TO ADJUST YOUR INFO FOR HOST, USER, PASSWORD AND DATABASE

#section for website backup
mkdir -p $HOME/html/_db_backups/site # create site directory if it doesn't already exist
cp -r $HOME/html/*.html $HOME/html/_db_backups/site # copy all .html files
cp -r $HOME/html/*.css $HOME/html/_db_backups/site # copy all .css files
cp -r $HOME/html/*.php $HOME/html/_db_backups/site # copy all .php files
cp -r $HOME/html/images $HOME/html/_db_backups/site # copy /images/ directory
tar -cvzPf $HOME/html/_db_backups/site_backup_$NOWDATE.tar.gz $HOME/html/_db_backups/site/* # zip site files
rm -r $HOME/html/_db_backups/site/*  # remove copies site files