re-bootstrap-slave-db new

1 files changed, 19 insertions, 0 deletions

diff --git a/re-bootstrap-slave-db b/re-bootstrap-slave-db
new file mode 100755
index 0000000..cf44385
--- /dev/null
+++ b/re-bootstrap-slave-db
@@ -0,0 +1,19 @@
+#!/bin/bash
+
+if [ $# -ne 1 ] || [ ! -f "$1" ]; then
+  >&2 echo 're-bootstrap-slave-db $db-dump-file'
+  exit 1
+fi
+
+{
+  printf 'STOP SLAVE;\n'
+  xzcat "${1}"
+  xzcat "${1}" \
+  | sed -n '
+    s/^-- CHANGE MASTER TO /CHANGE MASTER TO /
+    T
+    p
+  '
+  printf 'START SLAVE;\n'
+} \
+| mysql -u root -p