local/backup/mysql-snapshot

   1 #!/bin/sh -eu
   2 # SYNTAX: $database_pattern -- $snapshot_eval
   3 # DESCRIPTION: crée un instantané pour chaque base de données MySQL $database donnée
   4 # DESCRIPTION: dans ~backup/snapshot/mysql/"$database",
   5 # DESCRIPTION: puis évalue $snapshot_eval,
   6 # DESCRIPTION: puis efface l'instantané.
   7 ${TRACE:+set -x}
   8
   9 test "$(id -u)" = "$(id -u backup)"
  10
  11 database_pattern=$1; shift
  12 test ! "${1-}" = -- || shift
  13 test ! $# = 0 || set -- :
  14
  15 install -d -m 770 -o backup -g backup \
  16  ~backup/snapshot/mysql
  17
  18 trap_exit () {
  19         errno=$?
  20         test $errno = 0 ||
  21         cat >&2 <<-EOF
  22                 ERROR: $0 "$database" "$@"
  23                 EOF
  24         #return $errno
  25  }
  26 trap trap_exit EXIT
  27
  28 while IFS='' read -r database
  29  do
  30         test "${database:+set}"
  31         test ! -e ~backup/snapshot/mysql/$database
  32                 # NOTE: soit une sauvegarde est déjà en cours,
  33                 #       soit une précédente a échoué.
  34         can_hotcopy=yes
  35         while IFS='     ' read -r table engine
  36          do
  37                 case $engine in
  38                  (MyISAM|ARCHIVE) :;;
  39                  (*) can_hotcopy=no;;
  40                  esac
  41          done <<-EOF
  42                 $(mysql -u backup --batch --skip-column-names <<-EOF
  43                                 SELECT table_name,engine
  44                                         FROM information_schema.tables
  45                                         WHERE table_schema = '$database';
  46                                 EOF
  47                  )
  48                 EOF
  49         case $can_hotcopy in
  50          (yes)
  51                 cd /
  52                 sudo -u root find ~mysql-data -mindepth 1 -maxdepth 1 -type d -exec \
  53                  install -d -m 750 -o mysql -g backup {} +
  54                 cd - >/dev/null 2>&1
  55                 test "${TRACE:+set}" || quiet=--quiet
  56                 mysqlhotcopy --method=cp -u backup ${quiet:-} \
  57                  "$database" ~backup/snapshot/mysql
  58                 ;;
  59          (no)
  60                 install -d -m 770 -o backup -g backup \
  61                  ~backup/snapshot/mysql/"$database"
  62                 mysqldump --opt --events -u backup ${TRACE:+--verbose} \
  63                  --result-file ~backup/snapshot/mysql/$database/dump.sql \
  64                  "$database"
  65                 ;;
  66          esac
  67         eval "$@"
  68         rm -rf \
  69          ~backup/snapshot/mysql/"$database"
  70  done <<-EOF
  71         $(mysql -u backup --batch --skip-column-names <<-EOF
  72                 SELECT schema_name
  73                         FROM information_schema.schemata
  74                         WHERE schema_name NOT IN ('information_schema', 'performance_schema')
  75                         AND   schema_name LIKE '$database_pattern';
  76                 EOF
  77          )
  78         EOF