How to get mongo command results in to a flat file

mongodb mongodb-java mongodb-query
QVSJ picture QVSJ · Oct 10, 2012 · Viewed 51.3k times · Source

How do I export the results of a MongoDB command to a flat file

For example, If I am to get db.collectionname.find() into a flat file.

I tried db.collectionname.find() >> "test.txt" doesnt seem to work.

Answer

peshkira picture peshkira · Oct 10, 2012

you can try the following from the command line

mongo 127.0.0.1/db --eval "var c = db.collection.find(); while(c.hasNext()) {printjson(c.next())}" >> test.txt

assuming you have a database called 'db' running on localhost and a collection called 'collection' this will export all records into a file called test.txt

If you have a longer script that you want to execute you can also create a script.js file and just use

mongo 127.0.0.1/db script.js >> test.txt

I hope this helps

Related questions

Mongodb inserting doc without _id field

I am newbie to mongodb. I need to insert a doc without the _id field generating automatically. I need to set the field Tenant_id as unique or need to change the "_id" field to Tenant_id. how to do …

Read More
MongoDB: $in with an ObjectId array

Just a quick question about something I've just experienced and I'm still thinking about why: mongos> db.tickets.count({ "idReferenceList" : { "$in" : [ { "$oid" : "53f1f09f2cdcc8f339e5efa2"} , { "$oid" : "5409ae2e2cdc31c5aa0ce0a5"}]}}); 0 mongos> …

Read More
how to insert blob data in mongodb,is there any additaional software required

I have just installed mongodb on my system, I wanted to know if it was possible to insert blob data in mongodb. What is the procedure and if any other softwares is required for this ?

Read More