Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash
- ##################################################
- #### Script para importar dumps de MySQL #########
- #### #########
- #### Instruções: #########
- #### Sempre passar os parametros #########
- #### -u Nome de usuário #########
- #### -h Hostname #########
- #### -d Nome do Banco #########
- #### -f Caminho completo do SQL #########
- #### -p Senha (Opcional) #########
- #### #########
- ##################################################
- # Configurações
- # Onde está seu MySQL?
- MySQL="/opt/local/bin/mysql5"
- # Não precisa mexer daqui pra baixo ;)
- while getopts u:p:h:d:f: OPCAO; do
- case "${OPCAO}" in
- u) MyUser="${OPTARG}" ;;
- p) MyPass="${OPTARG}" ;;
- h) MyHost="${OPTARG}" ;;
- d) MyDb="${OPTARG}" ;;
- f) SQLFile="${OPTARG}" ;;
- esac
- done
- HavePass=$(echo ${#MyPass})
- if [ $HavePass -lt 1 ]; then
- $MySQL -h $MyHost -u$MyUser $MyDb < $SQLFile
- else
- $MySQL -h $MyHost -u$MyUser -p$MyPass $MyDb < $SQLFile
- fi
Add Comment
Please, Sign In to add comment