SQL Migration

gistfile1.txt

#!/bin/bash

sql_dump() {
    echo "Performing mysqldump on database $DBNAME @ $HOST"
    MYSQL_PWD=$PASSWORD mysqldump -h $HOST -P 3306 -u root $DBNAME > $DBNAME.sql
}

restore() {
    echo "Performing restore on database $DBNAME @ $HOST"
    MYSQL_PWD=$PASSWORD mysql -h $HOST -P 3306 -u root $DBNAME < $DBNAME.sql
}

# Get input
read -p 'Function: sql_dump or restore: ' FUNCTION
read -p 'DBName: ' DBNAME
read -p 'Host: ' HOST
read -sp 'Password: ' PASSWORD

if [[ -z $FUNCTION || -z $DBNAME || -z $HOST || -z $PASSWORD ]]
then
    echo "Not all params supplied"
else
    if [ "$FUNCTION" == "sql_dump" ]
    then
        sql_dump
    elif [ "$FUNCTION" == "restore" ]
    then
        restore
    else
        echo "Please use either 'sql_dump' or 'restore' as function"
    fi
fi