#!/bin/bash
 
DATE1=`date | awk '{print $3}'`
DATE2=`date | awk '{print $2}'`
DATE3=`date | awk '{print $6}'`
 
THEDATE="${DATE1}${DATE2}${DATE3}"
 
KEEPORIG=10
KEEPSECOND=30
 
KEEPSQLORIG=30
KEEPSQLSECOND=50
 
ORIGDIR="/root/Backups"
SECONDDIR="/secondarydir"
APACHEDIR="/var/www/html"
VHOSTSDIR="/var/www/vhosts"
 
MYSQLUSER=root
MYSQLPASS=pass
 
cd ${ORIGDIR} # chdir to the right dir
tar -cjvf "./MainApache_${THEDATE}.tar.bz2" ${APACHEDIR} # tar up apache dir
tar -cjvf "./Vhosts_${THEDATE}.tar.bz2" ${VHOSTSDIR} # tar up vhosts dir
 
mysqldump -u ${MYSQLUSER} -p${MYSQLPASS} -A > "./MySQL_${THEDATE}.sql" # dump db
bzip2 "./MySQL_${THEDATE}.sql" # compress db
 
cp -v "./MainApache_${THEDATE}.tar.bz2" ${SECONDDIR} # copy
cp -v "./Vhosts_${THEDATE}.tar.bz2" ${SECONDDIR} # copy
cp -v "./MySQL_${THEDATE}.sql.bz2" ${SECONDDIR} # copy
 
# prune .tar.bz2 in original folder
if [ `ls -1 "${ORIGDIR}" | grep .tar.bz2 | wc -l` -gt $KEEPORIG ]; then
i=1
for each in `ls -1t "${ORIGDIR}" | grep .tar.bz2`; do
if [ $i -gt $KEEPORIG ]; then
echo Removing "${ORIGDIR}/${each}"
rm -fv -- "${ORIGDIR}/${each}"
fi
let "i = i + 1"
done
fi
 
# prune .tar.bz2 in second folder
if [ `ls -1 ${SECONDDIR} | grep .tar.bz2 | wc -l` -gt $KEEPSECOND ]; then
i=1
for each in `ls -1t "${SECONDDIR}"`; do
if [ $i -gt $KEEPSECOND ]; then
echo Removing "${SECONDDIR}/${each}"
rm -fv -- "${SECONDDIR}/${each}"
fi
let "i = i + 1"
done
fi
 
# prune db dumps in original folder
if [ `ls -1 "${ORIGDIR}" | grep .sql.bz2 | wc -l` -gt $KEEPSQLORIG ]; then
i=1
for each in `ls -1t "${ORIGDIR}" | grep .sql.bz2`; do
if [ $i -gt $KEEPSQLORIG ]; then
echo Removing "${ORIGDIR}/${each}"
rm -fv -- "${ORIGDIR}/${each}"
fi
let "i = i + 1"
done
fi
 
# prune db dumps in second folder
if [ `ls -1 "${SECONDDIR}" | grep .sql.bz2 | wc -l` -gt $KEEPSQLSECOND ]; then
i=1
for each in `ls -1t "${SECONDDIR}" | grep .sql.bz2`; do
if [ $i -gt $KEEPSQLSECOND ]; then
echo Removing "${SECONDDIR}/${each}"
rm -fv -- "${SECONDDIR}/${each}"
fi
let "i = i + 1"
done
fi