Copy a Mysql database to another database

copy_mysql_database.sh

db=$1
new_db=$2

NUMARGS=$#

if [ $NUMARGS -eq 0 ]; then
    echo "Usage ./$0 db new_db"
    echo "Select one of the available databases:"
    bash -c 'mysql -u root --execute="show databases"'
    exit 1
fi

echo "Generating file $db.sql"
mysqldump $db -u root > $db.sql && \
mysqladmin create $new_db -u root && \
mysql $new_db -u root < $db.sql
echo "Creating $new_db"

echo "Check if db created:"
bash -c 'mysql -u root --execute="show databases"'