scripts/opensim/backup_opensim.sh

   1 #!/bin/bash
   2 # a simple script that backs up the opensim database assets.
   3
   4 gridusername="$1"; shift
   5 databasename="$1"; shift
   6
   7 if [ -z "$gridusername" ]; then
   8   gridusername=griduser
   9 fi
  10 if [ -z "$databasename" ]; then
  11   databasename=opensim
  12 fi
  13
  14 #hmmm: need to parameterize for the database name and secrets file and all that.
  15 #      would be nice to have a block of opensim variables, perhaps an associative
  16 #      array of config chunks.
  17
  18 source "$FEISTY_MEOW_SCRIPTS/core/functions.sh"
  19
  20 host=$(echo $(hostname) | sed -e 's/\([^.]*\)\..*/\1/')
  21
  22 bkupname="backup-opensim_${host}_$(date_stringer).mysql_bkup"
  23 mysqldump -u "$gridusername" -p$(cat $HOME/.secrets/opensim_db_password.txt) "$databasename" > "$bkupname"
  24 # note that the above assumes the database is called "opensim".  it might be
  25 # called opengrid instead, based on the setup procedure that was followed.
  26 # likewise the user might be someone other than "griduser".
  27 gzip "$bkupname"
  28