#!/bin/zsh
## copydb --- Create a copy of a database under a new name

## Commentary:

# Create a copy of the database specified as the first argument as a
# new database named by the second argument. Making usage:

#    copydb <from> <to>

# This doesn't try to check for any existing information, it just
# tries to create and copy. It is up to the user to make sure that
# that can actually be done.

# During execution it asks for the root password of MySQL so it can
# create a new database. It will also ask for another user and its
# password to load the database with, this may still be the same user,
# but allows one to specify different users if necessary.

## Code:

echo -n 'Database root PW (for DB creation): '
read -s ROOTPW
echo

echo -n 'Database user for new DB: '
read DBUSER

echo -n 'Database user PW for new DB: '
read -s DBPASSW
echo

mysql -u root -p"$ROOTPW" -B <<EOF
CREATE DATABASE \`$2\`;
GRANT ALL ON \`$2\`.* to '$DBUSER'@'localhost';
EOF

mysqldump -u "$DBUSER" -p"$DBPASSW" "$1" \
    | mysql -u "$DBUSER" -p"$DBPASSW" "$2" \
|| mysql -u root -p"$ROOTPW" -B <<EOF
DROP DATABASE \`$2\`;
EOF

unset ROOTPW