MySQL full backup

db-backup.sh

#!/bin/bash

#Database Connection
DBUSER=""
DBPASSWORD=""
DBNAME=""

#Location to save
BACKUPDIR="/opt/backup/database"
BACKUPPATH=$(date +"%m-%Y")
DATE=$(date +"%Y-%m-%d")

if [[ ! -d $BACKUPDIR/$BACKUPPATH ]]; then
    mkdir -p $BACKUPDIR/$BACKUPPATH
fi

mysqldump --user=$DBUSER --password=$DBPASSWORD $DBNAME  | bzip2 > $BACKUPDIR/$BACKUPPATH/$DBNAME-$DATE.sql.bz2

echo "$DBNAME-$DATE successfully backup"