1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 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