diff options
Diffstat (limited to 'bin/sqlbackup')
| -rwxr-xr-x | bin/sqlbackup | 13 |
1 files changed, 7 insertions, 6 deletions
diff --git a/bin/sqlbackup b/bin/sqlbackup index 69bbfbc..018d700 100755 --- a/bin/sqlbackup +++ b/bin/sqlbackup @@ -151,10 +151,10 @@ printf "File timestamp: %s\n" "$TIME" >> "$BLOG" mysql --user="$BUSER" --password="$(cat $PWFL)" -e "flush logs \\G" 2>> "$BLOG" if [ "$?" -ne 0 ];then [ ! -z "$LOGGER" ]&&[ "$LOGGER" -eq 1 ]&&mlogger err "flushing logs failed, check $BLOG" - [ "$SCHANAUZE" -ne 1 ]&&printf "$NEE\n\n" + [ "$SCHANAUZE" -ne 1 ]&&printf "%b\n\n" "$NEE" exit 101 else - [ "$SCHANAUZE" -ne 1 ]&&printf "$OGE\n\n" + [ "$SCHANAUZE" -ne 1 ]&&printf "%b\n\n" "$OGE" fi exit 0 LOGPOS="$(mysql --user="$BUSER" --password="$(cat $PWFL)" -e "show master status \G"|grep Position|awk '{print $NF}')" @@ -196,7 +196,7 @@ for i in "${DBARR[@]}";do fi if [ "$?" -ne 0 ];then [ ! -z "$LOGGER" ]&&[ "$LOGGER" -eq 1 ]&&mlogger err "backup of $i failed, check $BLOG" - [ "$SCHANAUZE" -ne 1 ]&&echo -e "$NEE" + [ "$SCHANAUZE" -ne 1 ]&&printf "%b\n" "$NEE" [ ! -z "$LOGGER" ]&&[ "$LOGGER" -eq 1 ]&&mlogger err "backup failed, check $BLOG" exit 2 fi @@ -204,7 +204,7 @@ for i in "${DBARR[@]}";do [ "$SCHANAUZE" -ne 1 ]&&printf ".. \033[u\033[K \033[1;30mcompression running...\033[0m" xz "$BDIR/$i-$TIME.sql"&&chmod 0600 "$BDIR/$i-$TIME.sql.xz" if [ "$?" -ne 0 ];then - [ "$SCHANAUZE" -ne 1 ]&&echo -e "$NEE" + [ "$SCHANAUZE" -ne 1 ]&&printf "%b\n" "$NEE" [ ! -z "$LOGGER" ]&&[ "$LOGGER" -eq 1 ]&&mlogger err "compression failed, check $BLOG" exit 3 fi @@ -215,9 +215,10 @@ done [ ! -z "$LOGGER" ]&&[ "$LOGGER" -eq 1 ]&&mlogger info "Purging binary logs..." mysql --user="$BUSER" --password="$(cat $PWFL)" -e "purge binary logs to \"$BINLOGF\" \\G" 2>> "$BLOG" if [ "$?" -ne 0 ];then - [ "$SCHANAUZE" -ne 1 ]&&echo -e "$NEE" + [ "$SCHANAUZE" -ne 1 ]&&printf "%b\n" "$NEE" [ ! -z "$LOGGER" ]&&[ "$LOGGER" -eq 1 ]&&mlogger err "purging of binary logs failed, check $BLOG" exit 3 fi sleep 0.1337 -echo -e "$OGE" +[ "$SCHANAUZE" -ne 1 ]&&printf "%b\n" "$OGE" +[ ! -z "$LOGGER" ]&&[ "$LOGGER" -eq 1 ]&&mlogger info "sqlbackup finished." |