local/mysql-backup-status

   1 #!/bin/sh -eu
   2 # SYNTAX: $databases [...]
   3 tool=$(readlink -e "${0%/*}/..")
   4 TRACE=${TRACE:-}
   5 . "$tool"/local/lib.sh
   6
   7 for database in $(sudo -u backup find ~backup/data/mysql \
   8  -mindepth 1 -maxdepth 1 -type d \
   9  ${@:+-false $(printf -- '-or -name %s\n' "$@")} \
  10  -printf '%f\n')
  11  do
  12         # NOTE: 0.9765625 = $(units -1 kilobytes kibibytes)
  13         size=$(bc <<-EOF
  14                 scale=0; print ($(sudo -u backup du -ks ~backup/data/mysql/"$database" | cut -f 1) * 0.9765625 / 1), " Kio"
  15                 EOF
  16          )
  17         info '' database size
  18         cat <<-EOF
  19                 ${tput_setaf_0}${tput_bold}
  20                 $(sudo -u backup ~backup/bin/duplicity 2>/dev/null \
  21                  --name mysql/"$database" \
  22                  collection-status \
  23                  file:///home/backup/data/mysql/"$database")
  24                 ${tput_sgr0}
  25                 EOF
  26  done