Skip to main content

Useful MongoDB commands

To export JSON from MongoDB Collection
 mongoexport -h replicaSet/primaryHost,secondaryHost -u username -p pwd --db dbName -c collectionName --quiet > collectionExport.json

To export BSON from MongoDB Collection
mongodump -h replicaSet/primaryHost,secondaryHost -u username -p pwd --db dbName -c collectionName -o - > collectionDump.bson

To export some fields in csv from MongoDB Collection
mongoexport --host primaryHost --db dbName --collection collectionName --fields 'field1,field2,field3' --out collection.csv --csv -u userName -p

To run javascript on MongoDB
mongo replicaSet/primaryHost,secondaryHost/dbName -u userName mongoScript.js -p

To restore bson in MongoDB
mongorestore --host primaryHost --db dbName --collection collectionName -u userName -p --drop  collectionName.bson
Labels:

Comments

Post a Comment

Popular posts from this blog

Install Central Logging on Amazon Linux

Goal: In these tutorial we gonna cover setup of central logging system on amazon linux (CentOs) in same aws vpc . We will setup one central log server to receive log using rsyslog, after that we will setup one client to forward apache & syslog to central server. we already covered forward logs from central log server to ELK stack for analyzing. Logging Stack Component: Central Log server Multiple logging client server/Any apache web server generating logs Rsyslog: we setup with rsyslog v8-stable. You can use any rsyslog  version after rsyslog-6, because we encountered rsyslog drop message in earlier version. Prerequisites: Rsyslog is quite light weight, we doesn't requirement any high configuration machine, aws t2.micro should be enough. We are running t2.micro in production for central log server to receive around 1000 log entry/second, server is using less then 2 percent/sec within same vpc. Now Let's Start we gonna break these tutorial in two pa...
Post a Comment
Read more

GoReplay - Testing Your Site with Actual Traffic

Goal:   In these article we gonna learn How to capture your Real Time traffic from production and reuse it at your testing/development environment. Prerequisite: One web server running, or If you are just playing around then you can run goreplay test ftp server. Let's Begin Load Testing for site serving millions user wasn't be that easy before I came to know GoReplay . Here I am not gonna explain you How great go replay is, You will automatically get to know after following steps above step to capture and replay your request logs. FYI GoReplay capture logs from tcpdump. Installation: Download zip file from there git repo and unzip it. # create a directory mkdir ~/goreplay # go to directory you created cd ~/goreplay # download tar file from goreplay git repo wget https://github.com/buger/goreplay/releases/download/v0.16.1/gor_0.16.1_x64.tar.gz # unzip it tar -xf gor_0.16.1_x64.tar.gz After Unzipping Check GoReplay binary File is available in directory. Ca...
Post a Comment
Read more

My First Azure Function app using CLI

Goal:      Here we will learn about creating and deploying our first azure function app on azure cloud, everything from command line.   Steps:      First we will start with installing all preliminary command line utilities. And then we will create function locally to test, debug and then we will deploy it on the azure cloud function app. Install npm as most of azure utilities written in node, so to download all dependencies we will require npm. sudo apt install npm Install python3 pip, virtual env with few other python development dependencies as we gonna develop our first app in python. sudo apt install -y python3-pip python3-venv build-essential libssl-dev libffi-dev python3-dev Install azure function command line utility to initialize, debug and publish functions and azure cli to interact with azure cloud. sudo npm install -g azure-function...
1 comment
Read more