scripts/opensim/backup_osgrid.sh

   1 #!/bin/bash
   2 # a simple script that backs up the opensim database assets.
   3
   4 source $FEISTY_MEOW_SCRIPTS/core/date_stringer.sh
   5
   6 host=$(echo $(hostname) | sed -e 's/\([^.]*\)\..*/\1/')
   7
   8 bkupname=osgrid_bkup_${host}_$(date_stringer).mysql_bkup
   9 mysqldump -u griduser -p$(cat $HOME/.secrets/opensim_db_password.txt) opengrid > $bkupname
  10 # note that the above assumes the database is called "opensim".  it might be
  11 # called opengrid instead, based on the setup procedure that was followed.
  12 # likewise the user might be someone other than "griduser".
  13 gzip $bkupname
  14
  15