#!/bin/bash
#

unset mv
unset cp
unset rm

# here you can set how many backups you want to keep in your folder
# hier stellt ihr ein nach wievielen Backups die alten ueberschrieben werden
KEEP="480"
BACKUPS=`find /home/backup -name "database_sqldump-*.gz" | wc -l | sed 's/\ //g'`

while expr $BACKUPS \> $KEEP &>/dev/null
do
ls -tr1 /root/backup/database_sqldump-*.gz | head -n 1 | xargs rm -f
BACKUPS=`expr $BACKUPS - 1`

done

DATE=`date +%d-%m-%Y-%H-%M-%S`

rm -f /home/backup/.database_sqldump-${DATE}.gz_INPROGRESS
nice -n 19 mysqldump --user=dbuser --password=dbpass -a -e --add-drop-table database | nice -n 19 gzip -c -9 > /home/backup/.database_sqldump-${DATE}.gz_INPROGRESS
mv -f /home/backup/.database_sqldump-${DATE}.gz_INPROGRESS /root/backup/database_sqldump-${DATE}.gz


exit 0