From 415475f697abd213f3d859162e1abeb5995d7ca7 Mon Sep 17 00:00:00 2001 From: Alexander Barton Date: Mon, 15 Feb 2016 11:56:54 +0100 Subject: [PATCH] mkmysqlslave: Disable binary log when importing from file --- bin/mkmysqlslave | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/bin/mkmysqlslave b/bin/mkmysqlslave index fa60b93..1804d8d 100755 --- a/bin/mkmysqlslave +++ b/bin/mkmysqlslave @@ -1,7 +1,7 @@ #!/bin/sh # # mkmysqlslave -- import MySQL master data and start slave -# Copyright (c)2015 Alexander Barton +# Copyright (c)2015-2016 Alexander Barton # # This program is free software; you can redistribute it and/or modify # it under the terms of the GNU General Public License as published by @@ -87,11 +87,11 @@ fi echo "Start: $(date)" if [ "$INFILE" != "-" ]; then echo "Importing \"$INFILE\" ..." - mysql -h "$MYHOST" -u "$MYUSER" $PWSWITCH <"$INFILE"; r=$? else echo "Importing from standard input ..." - mysql -h "$MYHOST" -u "$MYUSER" $PWSWITCH; r=$? fi +( echo "SET SESSION SQL_LOG_BIN=0;"; cat "$INFILE" ) \ + | mysql -h "$MYHOST" -u "$MYUSER" $PWSWITCH; r=$? echo "End: $(date)" if [ $r -ne 0 ]; then echo "MySQL import FAILED, code $r!" >&2 -- 2.39.2