2 # a simple script that backs up the opensim database assets.
4 #hmmm: need to parameterize for the database name and secrets file and all that.
5 # would be nice to have a block of opensim variables, perhaps an associative
6 # array of config chunks.
8 source "$FEISTY_MEOW_SCRIPTS/core/launch_feisty_meow.sh"
10 host=$(echo $(hostname) | sed -e 's/\([^.]*\)\..*/\1/')
12 bkupname="backup-osgrid_${host}_$(date_stringer).mysql_bkup"
13 mysqldump -u griduser -p$(cat $HOME/.secrets/opensim_db_password.txt) opengrid > "$bkupname"
14 # note that the above assumes the database is called "opensim". it might be
15 # called opengrid instead, based on the setup procedure that was followed.
16 # likewise the user might be someone other than "griduser".