MySQLDump Shell script for backup

You can use the following script to dump mysql database and can add to crontab entry for daily backup!

#!/bin/sh

DAY=`/bin/date +%Y%m%d`
TFILE="/backup/MYDB.$DAY.gz"
mysqldump -u root -p'MYPASSWORD' MYDB | gzip > $TFILE
echo "cache dump completed, dump script by rumi (hasan.emdad@mango.com.bd)"