mysql_clone.sh

#!/bin/bash

function print-help() {
    echo "Clone database, use locally only."
    echo ""
    echo "  mysql_clone username password old_db new_db"
    echo ""
    echo "Options:"
    echo ""
    echo "  username: Database username from where you want to copy database"
    echo ""
    echo "  password: Database password from where you want to copy database"
    echo ""
    echo "  old_db: Database from where you want to copy"
    echo ""
    echo "  new_db: Database to where you want to copy, will be created for you"
    echo ""
}

if [ "$#" -eq 1 ] && ([ "$1" = "-h" ] || [ "$1" = "--help" ]);
then
    print-help
    exit 0
fi

if [ "$#" -ne 4 ];
then
    echo "Invalid number of parameters. Use -h or --help for more info."
    exit 1
fi

echo "CREATE DATABASE $4" | mysql -u $1 --password=$2

mysqldump $3 -u $1 --password=$2 | mysql -u $1 --password=$2 $4

exit 0