working with mysql database backup

mysql_db_backup.sh

####################################################################################################
####################################################################################################
#
# ON-TIME BACKUP
#
# assuming we have large enough "/data" folder
# and we use root user without password
# then database will zipped using GZIP
 

#! /bin/bash

BACKUP_DIR="/data"
MYSQL_USER="root"
MYSQL=/usr/bin/mysql
MYSQLDUMP=/usr/bin/mysqldump
 
databases=`$MYSQL --user=$MYSQL_USER -e "SHOW DATABASES;" | grep -Ev "(Database|information_schema|performance_schema)"`
 
for db in $databases; do
  $MYSQLDUMP --force --opt --user=$MYSQL_USER --databases $db | gzip > "$BACKUP_DIR/$db.gz"
done

####################################################################################################
####################################################################################################
#
# SCHEDULED BACKUP
#
# assuming we have large enough "/data" folder
# databases will stored under "today folder"
# then database will zipped using GZIP

#! /bin/bash

TIMESTAMP=$(date +"%F")
BACKUP_DIR="/data"
MYSQL_USER="mysql_user"
MYSQL=/usr/bin/mysql
MYSQL_PASSWORD="mysql_password"
MYSQLDUMP=/usr/bin/mysqldump
 
mkdir -p "$BACKUP_DIR/$TIMESTAMP"
 
databases=`$MYSQL --user=$MYSQL_USER -p$MYSQL_PASSWORD -e "SHOW DATABASES;" | grep -Ev "(Database|information_schema|performance_schema)"`
 
for db in $databases; do
  $MYSQLDUMP --force --opt --user=$MYSQL_USER -p$MYSQL_PASSWORD --databases $db | gzip > "$BACKUP_DIR/$TIMESTAMP/$db.gz"
done