#!/bin/bash

# Customizable parameters
DATABASES="lportal sitescape"
MYSQLDUMPDIR=/mysqldumps
MYSQLDUMPFILE=mysqldump_`/bin/date "+%Y%m%d_%s"`.sql

if [[ ! -d $MYSQLDUMPDIR ]]
then
        mkdir -p $MYSQLDUMPDIR
fi

# Verify we don't have more than 20 backups
DUMPCOUNT=`ls $MYSQLDUMPDIR/*|wc -l|sed -e 's/ //g'`
if [[ $DUMPCOUNT -gt 20 ]]
then
        HEADCOUNT=`expr $DUMPCOUNT - 20`
        DELETEFILES=`ls -tr $MYSQLDUMPDIR/* | head -$HEADCOUNT`
        rm -f $DELETEFILES
fi

/usr/bin/mysqldump --quote-names --opt -u root --databases $DATABASES > $MYSQLDUMPDIR/$MYSQLDUMPFILE