search

DoSomething / lofi-schools-flask

Flask implementation of the school search service
MIT License
0 stars 2 forks source link

Back up database #6

Open mshmsh5000 opened 8 years ago

mshmsh5000 commented 8 years ago

Let's back up this database. Credentials are in the Heroku account.

sheyd commented 8 years ago

@mshmsh5000 The Mongolab login we have in LastPass doesn't host the LOFI school Mongo instance. Can you add whatever creds might be in your personal LastPass? The connection string isn't allowed from the office. I can try and creatively proxy through the Heroku instance, but I didn't find anything obvious to do that with.

mshmsh5000 commented 8 years ago

The original app creator must have provisioned the MongoLab instance from a different account.

To get the correct connection settings, from the project's root doc (and assuming you're authenticated to Heroku with the CLI tool):

$ heroku config | grep DB
=== lofischools Config Vars
LOFI_DB_HOST:     xxxxx.mongolab.com
LOFI_DB_NAME:     xyzxyz
LOFI_DB_PASSWORD: xyzxyz
LOFI_DB_PORT:     12345
LOFI_DB_USERNAME: xyzxyzxyz

I've imported into our main MongoLab account.

sheyd commented 8 years ago

Add indexes for following fields in Prod DB:

{ "_id" : 1}    
{ "zip" : 1}    
{ "state" : 1}
{ "city" : 1}
{ "city" : 1 , "state" : 1}