Copy mongo db from local to remote server (container instance with limited memory)

export-mongo-to-remote.sh

#!/bin/bash

#  dump
mongodump -vvv -d hmm-local-beta --gzip --excludeCollection=users --archive=/Path/to/mongo/archive.gz

#  old way, container runs out of memory :(
#scp -i ~/.ssh/cert_rsa ~/Path/to/mongo/archive.gz root@[remote host]:/root/import/
##ssh -i ~/.ssh/cert_rsa root@[remote host] "mongorestore -vvv --drop --gzip --stopOnError --archive=/root/import/hmm.gz"

#  new way - tunnel - this way we use local memory :)
ssh -fN -l root -i /Users/mnicola/.ssh/cert_rsa -L 9999:localhost:27017 [remote host]
mongorestore -vvv --drop --gzip --stopOnError --port 9999 --archive=/Path/to/mongo/archive.gz

echo "All done!"