#! /bin/sh # 20101217 masa # to start server # bin/bbmbd config="config.yml" # bin/yusd server_url="druby://localhost:12001" # if there is not the user 'sandoz' for the database 'sandoz_bbmb' # $ createuser sandoz -P # refer to: http://dev.ywesee.com/wiki.php/Masa/20101108-sample-ebook-setup-eshop BBMB_HOME='/home/masa/ywesee/bbmb' SAND_HOME='/home/masa/ywesee/sandoz.bbmb.ch' SETUP_DIR='/home/masa/sandoz.bbmb.ch_setup' yyyy=`date -d '1 days ago' +"%Y"` mm=`date -d '1 days ago' +"%m"` dd=`date -d '1 days ago' +"%d"` m=(dummy January February March April May June July August September October November December) nm=`expr $mm + 0` echo -n 'Are you sure to DELETE bbmb and sandoz.bbmb.ch directories (N/y) > ' read YN # Y or y if [ "$YN" = 'Y' ]||[ "$YN" = 'y' ]; then rm -rf $BBMB_HOME rm -rf $SAND_HOME git clone ssh://ywesee@scm.ywesee.com/home/ywesee/git/bbmb git clone ssh://ywesee@scm.ywesee.com/home/ywesee/git/sandoz.bbmb.ch cp $SETUP_DIR/config.yml $BBMB_HOME/ cp -rf $SAND_HOME/doc $BBMB_HOME/ cp -rf $SAND_HOME/lib $BBMB_HOME/ cd $BBMB_HOME mkdir data mkdir data/sql sudo -u postgres dropdb sandoz_bbmb sudo -u postgres createdb -E UTF8 -T template0 sandoz_bbmb echo ywesee@$WHITIE:/var/backup/whitie/db/postgresql/${m[nm]}-$yyyy/$yyyy-$mm-$dd/21\:00-postgresql_database-sandoz_bbmb-backup.gz scp ywesee@$WHITIE:/var/backup/whitie/db/postgresql/${m[nm]}-$yyyy/$yyyy-$mm-$dd/21\:00-postgresql_database-sandoz_bbmb-backup.gz data/sql/sandoz_bbmb.$yyyy$mm$dd.sql.gz cd data/sql zcat sandoz_bbmb.$yyyy$mm$dd.sql.gz | psql -U postgres sandoz_bbmb else echo "'N' selected. Ok. I do nothing." exit fi