MySQL Restore

restore.sh

#!/bin/bash

###################################################
## CREDENCIAIS DO MYSQL NO ARQUIVO /root/.my.cnf ##
##                                               ##
## [mysql]                                       ##
## user=root                                     ##
## password='M!nh@S3nh@'                         ##
## host='ip-ou-dns-do-servidor'                  ##
##                                               ##
## [mysqldump]                                   ##
## user=root                                     ##
## password='M!nh@S3nh@'                         ##
## host='ip-ou-dns-do-servidor'                  ##
##                                               ##
###################################################

DATA=`date +%Y/%m/%d`
BACKUP="/var/backups/mysql/$DATA"

gzip -d $BACKUP/*.gz

databases=`ls $BACKUP/ | cut -d'.' -f1`

for db in $databases; do
        mysql -e "DROP DATABASE $db" 2> /dev/null
        mysql -e "CREATE DATABASE $db" 2> /dev/null
        mysql $db < $BACKUP/$db.sql
done

mysql -e "FLUSH PRIVILEGES"