!/bin/bash

DB=thelo
DIR="/Library/WebServer/Documents/maintenance/backups/"
TAR=archive.tar

TS="\033[1m"
TR="\033[0m"

cd $DIR

for i in $( ls | grep db_ ); do
  sudo tar -rf $TAR $i
  sudo rm $i
done

if [ -e $TAR ]; then
  echo -e old files have been archived under $TS$TAR$TR
fi

FILE=db_$(date +%y%m%d)
sudo /usr/local/mysql/bin/mysqldump $DB > $DIR$FILE
echo -e database $TS$DB$TR has been created in $TS$DIR$TR as $TS$FILE$TR