#!/bin/bash

MYSQL_USER=root
MYSQL_PASSWORD=[PASSWORD]
DAY=$(date +%m-%d-%y-%T)

BACKUP_FOLDER="/home/ubuntu/databases/$DAY"
ZIP_FOLDER="/home/ubuntu/db_zip/"


#
if [ ! -d $BACKUP_FOLDER ]; then
        mkdir -p "$BACKUP_FOLDER"
fi

cd /var/lib/mysql

DATABASE_LIST=`find * -type d`

for DB in $DATABASE_LIST
do
        /usr/bin/mysqlhotcopy -u $MYSQL_USER -p $MYSQL_PASSWORD $DB $BACKUP_FOLDER --allowold --keepold
        echo "/usr/bin/mysqlhotcopy -u $MYSQL_USER -p $MYSQL_PASSWORD $DB $BACKUP_FOLDER --allowold --keepold"
done

zip -r $ZIP_FOLDER/$DAY.zip $BACKUP_FOLDER

rm -rf $BACKUP_FOLDER