#!/bin/bash
#
DATE=`date +%H`

BACKUP_DIR="/home/suppliers/backup"

DATABASE="suppliers"

umask 077;/usr/bin/mysqldump --single-transaction $DATABASE  | gzip -9 > $BACKUP_DIR/$DATABASE-$DATE.sql.gz

# set link to last backup
rm $BACKUP_DIR/latest.sql.gz
ln -s $BACKUP_DIR/$DATABASE-$DATE.sql.gz $BACKUP_DIR/latest.sql.gz
chmod 660 $BACKUP_DIR/$DATABASE-$DATE.sql.gz