Created
March 28, 2014 14:20
-
-
Save t-vieira/9833987 to your computer and use it in GitHub Desktop.
Script para Backup de Banco de Dados Mysql remoto
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#/bin/bash | |
##################################################################################### | |
# BACKUP REMOTO DE BANCO MYSQL, GERADO UM .sql PARA IMPORTAÇÃO PARA OUTRO SERVIDOR | |
# | |
# Feito por Tiago Vieira - tiago@tvieira.net - www.tvieira.net - www.tvieira.com.br | |
##################################################################################### | |
#Perguntando as informações necessárias para o backup e guardando em variável | |
echo "Qual o endereço do host de conexão?" | |
read host | |
echo "Qual o usuário do banco de dados?" | |
read usuario | |
echo "Qual a senha do usuário do banco de dados?" | |
read senha | |
echo "Qual o nome do banco de dados?" | |
read banco | |
echo "Qual o endereço que será salvo o backup? (sem / no final)" | |
read caminho | |
echo "-------------Iniciando o Backup do Banco de Dados MySQL-------------" | |
mysqldump --host=$host --user=$usuario --password=$senha $banco > $caminho/$banco.bkp.sql | |
echo "------------- Fim do Backup do Banco de Dados -------------" |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment