#!/bin/sh

suffix=`date +%d-%b-%Y`
dest=/Backup/semanal/mysql
cmd='/usr/bin/mysqldump'

databases=(`echo 'show databases;' | mysql -u admin --password='4dm1n.dbyr' | grep -v ^Database$`)

for d in "${databases[@]}"; do
if [[ $d != 'tmp' && $d != 'test' ]]
then
path="${dest}/${suffix}/${d}"
mkdir -p ${path}
${cmd} --user=admin --password='4dm1n.dbyr' --quick --create-options ${d} | bzip2 -c > ${path}/${d}.sql.bz2
fi
done

/bin/tar -cvzf /Backup/semanal/etc-${suffix}.tar.gz /etc >> /dev/null 2>&1
/bin/tar -cvzf /Backup/semanal/www-${suffix}.tar.gz /var/www >> /dev/null 2>&1




# delete old dumps (retain 5 days)
find /Backup/semanal -mtime +5 -exec rm -rf {} \;