diff options
Diffstat (limited to 're-bootstrap-slave-db')
-rwxr-xr-x | re-bootstrap-slave-db | 19 |
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 |