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

---
 copydb | 22 ++++++++++++++++++++++
 1 file changed, 22 insertions(+)
 create mode 100755 copydb

(limited to 'copydb')

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