Adding verbosity about flushing logs

1 files changed, 9 insertions, 0 deletions

diff --git a/bin/sqlbackup b/bin/sqlbackup
index 890f2f6..552198f 100755
--- a/bin/sqlbackup
+++ b/bin/sqlbackup
@@ -143,8 +143,17 @@ TIME="$(date +"%Y-%m-%dT%H:%M:%S%z")"
 [ "$SCHANAUZE" -ne 1 ]&&printf "File timestamp: %s\n" "$TIME"
 printf "File timestamp: %s\n" "$TIME" > "$BLOG"
 # Flush prior to backups, do not purge.
+[ "$SCHANAUZE" -ne 1 ]&&printf "\n[....] Flushing logs.\033[s..\033[0m"
 [ ! -z "$LOGGER" ]&&[ "$LOGGER" -eq 1 ]&&mlogger info "flushing logs"
 mysql --user="$BUSER" --password="$(cat $PWFL)" -e "flush logs \\G"
+if [ "$?" -ne 0 ];then
+	[ ! -z "$LOGGER" ]&&[ "$LOGGER" -eq 1 ]&&mlogger err "flushing logs failed, check $BLOG"
+	[ "$SCHANAUZE" -ne 1 ]&&printf "$NEE\n\n"
+	exit 101
+else
+	[ "$SCHANAUZE" -ne 1 ]&&printf "$OGE\n\n"
+fi
+exit 0
 LOGPOS="$(mysql --user="$BUSER" --password="$(cat $PWFL)" -e "show master status \G"|grep Position|awk '{print $NF}')"
 [ "$SCHANAUZE" -ne 1 ]&&printf "Log position: %s\n" "$LOGPOS"
 printf "Log position: %s\n" "$LOGPOS" > "$BLOG"