Small Linux shell script to backup MySQL Database

This shell script can be used to take mysql database backup. To make backup process automatically you have to call this shellscript using Cron Job.

#!/bin/sh
#MySQL Database Backup Script
#-----------------------------

#Config
DB="database" #Database to backup
USER="user" #Your MySQL User
PASS="password" #Your MySQL Password
BACKUP_DIR="/root/backup" #Path to your backup directory
MYSQL_BIN_DIR="/var/mysql/bin" #Path to your MySQL bin folder
#Config

DT=`date '+%d_%b_%Y_%H_%M_%S'`
FILE=$BACKUP_DIR/$DB'_DB_BK_'$DT.sql

$MYSQL_BIN_DIR/mysqldump $DB > $FILE -u $USER -p$PASS
gzip $FILE