#!/bin/bash -ex

# MySQL Host
HOST=192.168.2.26
# MySQL User
USER='root'
# MySQL Password
PASSWORD='root'
# Backup Directory - NO TAILING SLASH!
OUTPUT="."

##### And
TIMESTAMP=`date +%Y%m%d_%H%M%S`;
mkdir $OUTPUT/$TIMESTAMP;
cd $OUTPUT/$TIMESTAMP;
echo "Starting MySQL Backup";
echo `date`;
databases=`mysql -h $HOST --user=$USER --password=$PASSWORD --batch --skip-column-names -e "SHOW DATABASES;" | grep -v 'mysql\|information_schema' | grep -v performance_schema`
for db in $databases; do
  if [[ "$db" != "information_schema" ]] && [[ "$db" != _* ]] ; then
    echo "Dumping database: $db"
    mysqldump -h $HOST --force --opt --user=$USER --password=$PASSWORD \
      --quote-names --dump-date --single-transaction \
      --events --routines --triggers \
      --databases $db \
      --result-file="${OUTPUT}/dbbackup-${TIMESTAMP}-${db}.sql"
    #gzip $OUTPUT/dbbackup-$TIMESTAMP-$db.sql
  fi
done
echo "Finished MySQL Backup";
echo `date`;