Dump Mongo Collection into JSON format

Question

Is there any way to dump mongo collection into json format  Either on the shell or using java driver I am looking for the one with best performance

User · Answer

If you want to dump all collections  run this command   mongodump -d  DB NAME    -o  tmp    It will generate all collections data in json and bson extensions into  tmp  DB NAME  directory

User · Answer

From the Mongo documentation      The mongoexport utility takes a collection and exports to either JSON or CSV  You can specify a filter for the query  or a list of fields to output   Read more here  http   www mongodb org display DOCS mongoexport

User · Answer

Mongo includes a mongoexport utility  see docs  which can dump a collection  This utility uses the native libmongoclient and is likely the fastest method   mongoexport -d  lt database gt  -c  lt collection name gt    Also helpful   -o  write the output to file  otherwise standard output is used  docs   --jsonArray  generates a valid json document  instead of one json object per  line  docs   --pretty  outputs formatted json  docs

User · Answer

Use mongoexport mongoimport to dump restore a collection   Export JSON File    mongoexport --db  lt database-name gt  --collection  lt collection-name gt  --out output json  Import JSON File    mongoimport --db  lt database-name gt  --collection  lt collection-name gt  --file input json     WARNING   mongoimport and mongoexport do not reliably preserve all rich BSON data types because JSON can only represent a subset of the types supported by BSON  As a result  data exported or imported with these tools may lose some measure of fidelity    Also  http   bsonspec org      BSON is designed to be fast to encode and decode  For example    integers are stored as 32  or 64  bit integers  so they don t need to   be parsed to and from text  This uses more space than JSON for small   integers  but is much faster to parse       In addition to compactness  BSON adds additional data types   unavailable in JSON  notably the BinData and Date data types

User · Answer

Here s mine command for reference   mongoexport --db AppDB --collection files --pretty --out output json     On Windows 7  MongoDB 3 4   one has to move the cmd to the place where mongod exe and mongo exe file resides    C  MongoDB Server 3 4 bin else it won t work saying it does not recongnize mongoexport command

[json] Dump Mongo Collection into JSON format

Examples related to json

Examples related to mongodb

Examples related to dump