#!/bin/sh
TODAY=`date “+%Y-%h-%d”`
FILENAME=”$TODAY-backup.sql”
echo $FILENAME
/usr/local/mysql/bin/mysqldump -uusername -ppassword database_name > /path/to/store/$FILENAME
tar -cvzf /path/to/store/$FILENAME.tar.gz /path/to/store/$FILENAME
rm /path/to/store/$FILENAME