#!/bin/bash

#parando a replicação
## SE NAO TIVER REPLICACAO, COMENTE A LINHA ABAIXO #
mysql -uadm.backup -e 'stop slave';

####################################
#Passando os parametros de controle#
####################################

#usuário
USER=""

#Senha
PASSWORD=""

#Diretório de output
OUTPUT=""


################################################
#Listando os bancos que serao feitos os backups#
################################################
databases=`mysql --user=$USER -e "SHOW DATABASES;" | tr -d "| " | grep -v Database`


###################
# INCIANDO O DUMP #
###################
for db in $databases; do
    if [[ "$db" != "information_schema" ]] && [[ "$db" != "performance_schema" ]] ; then
        echo "Dumping database: $db"
        mysqldump --force --opt --max_allowed_packet=2048M --single-transaction --quick --user=$USER --databases $db > $OUTPUT/`date +%Y-%m-%d`_$db.sql
        gzip $OUTPUT/`date +%Y-%m-%d`_$db.sql

fi
done


## SE NAO TIVER OS PARAMETROS DE CONTROLE, COMENTE A LINHA ABAIXO #
mysql -uadm.backup -e 'start slave';