X-Git-Url: https://feistymeow.org/gitweb/?a=blobdiff_plain;f=scripts%2Fopensim%2Fbackup_opensim.sh;h=508cad3fae82f3c41c4354fec46c0440f118f761;hb=8064b3bda39bcb17d8550006a2e99cd9e5cfadee;hp=5c18e55b90e233c2c41b47bd7fa732b7421e21f9;hpb=dbe3a7d9104352d69efdaa5eca600908ecc9bba8;p=feisty_meow.git diff --git a/scripts/opensim/backup_opensim.sh b/scripts/opensim/backup_opensim.sh index 5c18e55b..508cad3f 100644 --- a/scripts/opensim/backup_opensim.sh +++ b/scripts/opensim/backup_opensim.sh @@ -1,15 +1,22 @@ #!/bin/bash # a simple script that backs up the opensim database assets. -source $FEISTY_MEOW_SCRIPTS/core/date_stringer.sh +gridusername="$1"; shift +databasename="$1"; shift -host=$(echo $(hostname) | sed -e 's/\([^.]*\)\..*/\1/') +if [ -z "$gridusername" -o -z "$databasename" ]; then + echo " +This script takes two parameters: (1) the user name for the opensim database +and (2) the database name. It will backup that database by logging into +mysql as the user. The user's password for mysql must be recorded in a local +file called: \$HOME/.secrets/opensim_db_password.txt" +fi + +source "$FEISTY_MEOW_SCRIPTS/core/launch_feisty_meow.sh" -bkupname=opensim_bkup_${host}_$(date_stringer).mysql_bkup -mysqldump -u griduser -p$(cat $HOME/.secrets/opensim_db_password.txt) opensim > $bkupname -# note that the above assumes the database is called "opensim". it might be -# called opengrid instead, based on the setup procedure that was followed. -# likewise the user might be someone other than "griduser". -gzip $bkupname +host=$(echo $(hostname) | sed -e 's/\([^.]*\)\..*/\1/') +bkupname="backup-opensim_${host}_$(date_stringer).mysql_bkup" +mysqldump -u "$gridusername" -p$(cat $HOME/.secrets/opensim_db_password.txt) "$databasename" > "$bkupname" +gzip "$bkupname"