During my Xed restoring of data I decided to make a script for this...
db-restore.sh
#!/bin/bash RESET_DIR="$(dirname $0)" MANAGE_PY="/home/vagrant/norduni/src/niweb/manage.py" NOCLOOK_DIR="/home/vagrant/norduni/src/scripts" NEO4J_DIR="/home/vagrant/neo4j-community-2.1.6" function now (){ date +"%Y-%m-%d %H:%M:%S" } function msg(){ echo "> $1 - $(now)" } msg "Stopping neo4j" $NEO4J_DIR/bin/neo4j stop msg "Removing neo4j data" rm -rf $NEO4J_DIR/data/* msg "Starting neo4j again" $NEO4J_DIR/bin/neo4j start msg "Adding indexes to neo4j" curl -D - -H "Content-Type: application/json" --data '{"name" : "node_auto_index","config" : {"type" : "fulltext","provider" : "lucene"}}' -X POST http://localhost:7474/db/data/index/node/ curl -D - -H "Content-Type: application/json" --data '{"name" : "relationship_auto_index","config" : {"type" : "fulltext","provider" : "lucene"}}' -X POST http://localhost:7474/db/data/index/relationship/ msg "Drop, Create, Grant on DB" sudo -u postgres psql -f "$RESET_DIR/sql/drop-create-grant.sql" msg "Python migrate" python $MANAGE_PY syncdb python $MANAGE_PY migrate apps.noclook python $MANAGE_PY migrate actstream python $MANAGE_PY migrate tastypie msg "Reset DB sequences" sudo -u postgres psql -f "$RESET_DIR/sql/reset-sequences-noclook.sql" norduni msg "Importing data from json" cd $NOCLOOK_DIR python noclook_consumer.py -C $RESET_DIR/restore.conf -I