create_mysql_dumps

#!/bin/bash
echo "Mysql complete hot backup started"
DEST="/dest-path"
USERNAME="username"
PASSWORD="password"

databases=`mysql -u$USERNAME -p$PASSWORD -e "show databases;" | grep -v +----------------------+ | grep -v Database | grep -v information_schema`
INFO_SCHEMA="information_schema"

if [ ! -d $DEST ]; then
  echo "Create $DEST"
  mkdir $DEST
fi

mysqldump $INFO_SCHEMA --lock-table=false -\u$USERNAME -p$PASSWORD > $DEST/$INFO_SCHEMA.dump
gzip --force $DEST/$INFO_SCHEMA.dump

for database in $databases
do
  echo "Dump  $database"
  mysqldump $database -u$USERNAME -p$PASSWORD > $DEST/$database.dump
  gzip --force $DEST/$database.dump
done