#!/bin/bash

NOW=$(date +"%d%m%Y")
DEST="backups"

# Set mysql login info
MUSER="root"
MPASS=""
MHOST="127.0.0.1"

# Guess binary names
MYSQL="$(which mysql)"
MYSQLDUMP="$(which mysqldump)"
GZIP="$(which gzip)"

[ ! -d "${DEST}" ] && mkdir -p "${DEST}"
# Get all db names
# DBS="$($MYSQL -u $MUSER -h $MHOST -p$MPASS -Bse 'show databases')"
DBS="$($MYSQL -u $MUSER -h $MHOST -Bse 'show databases')"
for db in $DBS
do
 FILE=${DEST}/${db}_${NOW}.gz
 # Get around error
 # $MYSQLDUMP --single-transaction -u $MUSER -h $MHOST -p$MPASS $db | $GZIP -9 > $FILE
 $MYSQLDUMP --single-transaction -u $MUSER -h $MHOST $db | $GZIP -9 > $FILE
done