debian/scripts/koha-dump

   1 #!/bin/sh
   2 #
   3 # koha-dump: dump all contents and configs for a Koha site
   4 # Copyright 2010  Catalyst IT, Ltd
   5 #
   6 # This program is free software: you can redistribute it and/or modify
   7 # it under the terms of the GNU General Public License as published by
   8 # the Free Software Foundation, either version 3 of the License, or
   9 # (at your option) any later version.
  10 #
  11 # This program is distributed in the hope that it will be useful,
  12 # but WITHOUT ANY WARRANTY; without even the implied warranty of
  13 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  14 # GNU General Public License for more details.
  15 #
  16 # You should have received a copy of the GNU General Public License
  17 # along with this program.  If not, see <http://www.gnu.org/licenses/>.
  18
  19
  20 set -e
  21
  22
  23 # Make sure the files we create are not accessible by anyone else.
  24 umask 0077
  25
  26
  27 die() {
  28     echo "$@" 1>&2
  29     exit 1
  30 }
  31
  32
  33 # Parse command line.
  34 [ "$#" = 1 ] || die "Usage: $0 instancename"
  35 name="$1"
  36 kohaconfig="/etc/koha/sites/$name/koha-conf.xml"
  37 date="$(date +%Y-%m-%d)"
  38
  39 echo "Dumping Koha site $name:"
  40
  41
  42 # Dump database.
  43 mysqlhost="$( xmlstarlet sel -t -v 'yazgfs/config/hostname' $kohaconfig )"
  44 mysqldb="$( xmlstarlet sel -t -v 'yazgfs/config/database' $kohaconfig )"
  45 mysqluser="$( xmlstarlet sel -t -v 'yazgfs/config/user' $kohaconfig )"
  46 mysqlpass="$( xmlstarlet sel -t -v 'yazgfs/config/pass' $kohaconfig )"
  47 backupdir="$( xmlstarlet sel -t -v 'yazgfs/config/backupdir' $kohaconfig || true )"
  48 [ -z "$backupdir" ] && backupdir="/var/spool/koha/$name"
  49 dbdump="$backupdir/$name-$date.sql.gz"
  50 echo "* DB to $dbdump"
  51 mysqldump --databases --host="$mysqlhost" \
  52     --user="$mysqluser" --password="$mysqlpass" "$mysqldb" |
  53     gzip > "$dbdump"
  54 chown "root:$name-koha" "$dbdump"
  55 chmod g+r "$dbdump"
  56
  57
  58 # Dump configs, logs, etc.
  59 metadump="$backupdir/$name-$date.tar.gz"
  60 echo "* configs, logs to $metadump"
  61 tar -C / -czf "$metadump" \
  62     "etc/koha/sites/$name" \
  63     "etc/apache2/sites-available/$name" \
  64     "etc/apache2/sites-enabled/$name" \
  65     "var/lib/koha/$name" \
  66     "var/log/koha/$name"
  67
  68 echo "Done."