Export database from MongoDb atlas to the local machine Monogo compass

Question

I have remote database in Atlas with name of "test" and I want to download collection name image_table as a JSON file.

In mac terminal:

$ mongoexport –db test –collection image_table image.json I got the error>

020-01-16T13:49:12.822+0100 error parsing command line options: too many positional arguments: [–db test –collection image_table image.json] 2020-01-16T13:49:12.822+0100 try 'mongoexport --help' for more information

Answer 1

I could find a bit more straightforward answer in Mongo Compass :

Just install mongo compass connect to your atlas remote DB: get the hostname like "cluster0-shard-00-00-rcapo.mongodb.net XXXXX" from your remote altas cluster then connect to the database.

then you can download each document as JSON or CSV format. thanks, mongo DB compass developers team.

Answer 2

MongoDB Compass has many flaws and may fail you even with such a trivial task as exporting a collection. E.g. it will skip some fields in the export. The app itself says: "The fields displayed are from a sample of documents in the collection...". From my experience, a sample Compass uses is very small. I lost data even when exporting 100 documents or so.

Using mongoexport is easy. If you use mongo 3.6+, this will work:

mongoexport --uri mongodb+srv://<username>@atlas-cluster-url.mongodb.net/<db-name> --collection <collection-name> --out <path-to-export>