1 files changed, 14 insertions, 0 deletions
diff --git a/rebasedb b/rebasedb
new file mode 100755
index 0000000..6b41fd4
--- /dev/null
+++ b/rebasedb
@@ -0,0 +1,14 @@
+#!/bin/zsh
+
+echo -n 'Database root PW (for DB manipulation): '
+read -s ROOTPW
+echo
+
+mysql -u root -p"$ROOTPW" -B <<EOF
+DROP DATABASE $2; CREATE DATABASE $2;
+EOF
+echo "Recreated database $2"
+
+mysqldump -u root -p"$ROOTPW" "$1" \
+    | mysql -u root -p"$ROOTPW" -B "$2"
+echo "Copied $1 to $2"