establish database backup process

[cjlee112]

First note that most spnet data are (also) stored in Google+, so in principle even if we deleted our mongoDB database, only a few "private data" types would be gone forever:

• your reading list
• the list of papers you tagged as interesting
• topic subscriptions (once we give people an interface to create those).

(Everything else could be recovered by one #spnetwork query). All the same, we need to set up a backup process, to protect against data loss in case something bad happens to our webfaction server:

• immediately: a data dump process so we can keep off-site backups;
• soon: set up real replication (to another webfaction box?). Mongodb is supposed to be good at this, we need to take advantage of this to secure our data.

[cjlee112]

OK, I performed basic backup procedure from webapps/mongodb directory:

mongodb-linux-x86_64-2.4.1/bin/mongodump --port 26966 --username backup --db spnet --password
tar cvzf dump.tgz dump

I then scp'd the dump.tgz file (18 MB) to a safe location.

Note this first required creating backup user in the spnet db:

mongodb-linux-x86_64-2.4.1/bin/mongo --port 26966 admin
> db.auth('admin', PASSWORD)
> use spnet
> db.addUser( { user: "backup", roles: ["readWrite", "dbAdmin", "userAdmin"], pwd: PASSWORD } )