1 files changed, 22 insertions, 0 deletions
diff --git a/copydb b/copydb
new file mode 100755
index 0000000..51e5602
--- /dev/null
+++ b/copydb
@@ -0,0 +1,22 @@
+#!/bin/zsh
+
+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
+
+unset ROOTPW
+
+mysqldump -u "$DBUSER" -p"$DBPASSW" "$1" \
+    | mysql -u "$DBUSER" -p"$DBPASSW" "$2"