#!/bin/bash

## CONF ##
DBUSER=mangos
DBPASSWORD=mangos
DBSERVER=localhost
############
DBSNAME="$1"
DBNAME="$2"

if [ "$DBSNAME" ] && [ "$DBNAME" ]; then
  read -n1 -r -p "Press SPACE to start COPY db \"${DBSNAME}\" to \"${DBNAME}\" or CTRL+C to EXIT" KEY
  if [ "$KEY" = '' ]; then
    mysql_config_editor set --login-path=local --host=$DBSERVER --user=$DBUSER --password=$DBPASSWORD
    echo "Copying database ... (may take a while ...)"
    mysqldump $DBSNAME | mysql $DBNAME
  fi
fi

if [ "$1" = "help" -o "$1" = "-help" -o "$1" = "-h" -o "$1" = "" -o "$2" = "" ]; then
  echo ""
  echo "Command: ./copyDB sourceDB targetDB"
  echo ""
fi