From 1e32fe78f689490cfdeb8bb7b0b33edcfc019946 Mon Sep 17 00:00:00 2001
From: Tom Willemse
Date: Mon, 22 Jul 2013 23:01:45 +0200
Subject: Initial commit

---
 rebasedb | 14 ++++++++++++++
 1 file changed, 14 insertions(+)
 create mode 100755 rebasedb

(limited to 'rebasedb')

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"
-- 
cgit v1.3-2-g0d8e