remote/mysql-backup

   1 #!/bin/sh -eu
   2 tool=$(readlink -e "${0%/*}/..")
   3 . "$tool"/remote/lib.sh
   4
   5 mkdir -p "$tool"/var/backup/mysql
   6 "$tool"/remote/ssh -l backup '
   7         for db in $(sudo -u backup mysql -u backup --skip-column-names <<-EOF
   8                 SELECT schema_name
   9                         FROM information_schema.schemata
  10                         WHERE schema_name NOT IN ("information_schema", "performance_schema");
  11                 EOF
  12          ); do
  13                 echo $db
  14          done
  15  '