Backup MySql server database using bash script

Create the bash shell script for taking the My Sql server database backup

#vim mysqlbackup.sh

#!/bin/sh

# backup mysql databases shell script

DATE=$(date +%Y-%m-%d)

MYSQL=$(which mysql)

MYSQLDUMP=$(which mysqldump)

MYSQL_USER="root"

MYSQL_PASS="password"

HOSTNAME=$(hostname)

GZIP=$(which gzip)

ARG="-u $MYSQL_USER -p$MYSQL_PASS"

DATABASES=$($MYSQL $ARG -s -e "SHOW DATABASES;")

BACKUP_PATH="/home/backup/$DATE/mysql"

! [ -d $BACKUP_PATH ] && mkdir -p $BACKUP_PATH

for DB in $DATABASES

do

BACKUP_FILE="$BACKUP_PATH/$HOSTNAME-mysql-$DB-$DATE.sql.gz"

$MYSQLDUMP $ARG $DB | $GZIP -9 > $BACKUP_FILE

done

:wq