From 6f146ea65ae86ff01904ddfceb9e266b42d35fa5 Mon Sep 17 00:00:00 2001 From: Harald Pfeiffer Date: Fri, 3 Apr 2020 16:35:37 +0200 Subject: Adding verbosity about flushing logs --- bin/sqlbackup | 9 +++++++++ 1 file changed, 9 insertions(+) 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" -- cgit v1.2.3