How to export data from mongodb to json

Question

I am a beginner and trying to import data from MongoDB. The Robo3T which I use for visualization shows something like below.

--Kins
    Kins

And this is the command I use

mongoexport --db kins --collection test --out output.json

mongoexport --db kins.kins --collection test --out output.json

mongoexport --db [kins].[kins] --collection test --out output.json

But none of them work. What's the correct syntax?

How to import data in json format. Please guide me.

Link I reviewed:

Dump Mongo Collection into JSON format

`mongoexport --db kins --collection test --host kins --out output.json` — Valijon, Jan 10 '20 at 19:25
It seems you want to export data to a json from a replica set instance: If that's correct use this: `mongoexport --host="rsName/rs1:27017,rs2:27017,rs3:27017" --collection=test --db=kins --out=output.json` [See docs](https://docs.mongodb.com/manual/reference/program/mongoexport/#connect-to-a-replica-set) — ambianBeing, Jan 10 '20 at 19:25
@Unbreakable go through the documentation link. See if that helps. — ambianBeing, Jan 10 '20 at 19:29

score 0 · Answer 1 · answered Jan 10 '20 at 19:40

I guess you want to use the --jsonArray (docs) flag because by default mongoexport writes data using one JSON document for every MongoDB document.

mongoexport --db kins.kins --collection test --out output.json --jsonArray

You can consider using the --pretty (docs) flag too. It will output documents in pretty-printed format.

How to export data from mongodb to json

1 Answers1