Untitled

#!/bin/sh

if [ -e /tmp/cronlock ]
        then
        echo "cronjob locked"
        logger backup_db.sh Failed, Is Job Already Running?
        exit 1
fi

touch /tmp/cronlock

for I in $(mysql -uprimabackup -p36bz2jkz1eczzc3na9ln -e 'show databases' -s --skip-column-names );
        do mysqldump -uprimabackup -p36bz2jkz1eczzc3na9ln $I | bzip2 -c > "/var/dbbackups/$I.sql.bz2";
done

rm -f /tmp/cronlock

logger backup_db.sh Success