#! /bin/bash

TIMESTAMP=$(date +"%F")
#user credential
USERNAME=""
PASSWORD=""

#MYSQL = $bash>which mysql here
#MYSQLDUMP= $bash>which mysqldump here

MYSQLDUMP=/usr/bin/mysqldump
MYSQL=/usr/bin/mysql

#BACKUP_DIR = backup directory location
BACKUP_DIR="/home/user/mysql/$TIMESTAMP"

mkdir -p "$BACKUP_DIR"

databases=`$MYSQL --user=$USERNAME -p$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 > "$BACKUP_DIR/$db.sql"
done