Import MySQL dump to a database using parameters

migration.sh

#!/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