mongoexport Examples

Export in CSV Format

mongoexport --db=users --collection=contacts --type=csv --fields=name,address --out=/opt/backups/contacts.csv

name, address
Sophie Monroe, 123 Example Road
Charles Yu, 345 Sample Street

name
address

mongoexport --db=users --collection=contacts --type=csv --fieldFile=fields.txt --out=/opt/backups/contacts.csv

mongoexport --db=users --collection=contacts --type=csv --fields=name,address --noHeaderLine --out=/opt/backups/contacts.csv

Sophie Monroe, 123 Example Road
Charles Yu, 345 Sample Street

Export in JSON Format

This example creates an export of the contacts collection from the MongoDB instance running on the localhost port number 27017. This writes the export to the contacts.json file in JSON format.

mongoexport --db=sales --collection=contacts --out=contacts.json

Export from Remote Host Running with Authentication

The following example exports the contacts collection in the marketing database from a remote MongoDB instance that requires authentication.

Specify the:

• --host

• --port

• --username

• --authenticationDatabase

• --collection

• --db

• --out

mongoexport --host=mongodb1.example.net --port=27017 --username=someUser --authenticationDatabase=admin --collection=contacts --db=marketing --out=mdb1-examplenet.json

Alternatively, you use the --uri option to specify the host, port, username, authentication database, and db.

mongoexport --uri='mongodb://[email protected]:27017/marketing?authsource=admin' --collection=contacts --out=mdb1-examplenet.json

Export Query Results

You can export only the results of a query by supplying a query filter with the --query option, and limit the results to a single database using the "--db" option.

For instance, this command returns all documents in the sales database's contacts collection that contain a field named dept equal to "ABC" and the field date greater than or equal to ISODate("2018-01-01") (using the canonical format for dates { "$date": "YYYY-MM-DDTHH:mm:ss.mmm<offset>"} )

mongoexport --db=sales --collection=contacts --query='{"dept": "ABC", date: { $gte: { "$date": "2018-01-01T00:00:00.000Z" } }}'

You must enclose the query document in single quotes ('{ ... }') to ensure that it does not interact with your shell environment.

Connect to a MongoDB Atlas Cluster using AWS IAM Credentials

To connect to a MongoDB Atlas cluster which has been configured to support authentication via AWS IAM credentials, provide a connection string to mongoexport similar to the following:

mongoexport 'mongodb+srv://<aws access key id>:<aws secret access key>@cluster0.example.com/testdb?authSource=$external&authMechanism=MONGODB-AWS' <other options>

Connecting to Atlas using AWS IAM credentials in this manner uses the MONGODB-AWS authentication mechanism and the $external authSource, as shown in this example.

If using an AWS session token, as well, provide it with the AWS_SESSION_TOKEN authMechanismProperties value, as follows:

mongoexport 'mongodb+srv://<aws access key id>:<aws secret access key>@cluster0.example.com/testdb?authSource=$external&authMechanism=MONGODB-AWS&authMechanismProperties=AWS_SESSION_TOKEN:<aws session token>' <other options>

: / ? # [ ] @

Alternatively, the AWS access key ID, secret access key, and optionally session token can each be provided outside of the connection string using the --username, --password, and --awsSessionToken options instead, like so:

mongoexport 'mongodb+srv://cluster0.example.com/testdb?authSource=$external&authMechanism=MONGODB-AWS' --username <aws access key id> --password <aws secret access key> --awsSessionToken <aws session token> <other options>

When provided as command line parameters, these three options do not require percent encoding.

You may also set these credentials on your platform using standard AWS IAM environment variables. mongoexport checks for the following environment variables when you use the MONGODB-AWS authentication mechanism:

• AWS_ACCESS_KEY_ID

• AWS_SECRET_ACCESS_KEY

• AWS_SESSION_TOKEN

If set, these credentials do not need to be specified in the connection string or via their explicit options.

The following example sets these environment variables in the bash shell:

export AWS_ACCESS_KEY_ID='<aws access key id>'
export AWS_SECRET_ACCESS_KEY='<aws secret access key>'
export AWS_SESSION_TOKEN='<aws session token>'

Syntax for setting environment variables in other shells will be different. Consult the documentation for your platform for more information.

You can verify that these environment variables have been set with the following command:

env | grep AWS

Once set, the following example connects to a MongoDB Atlas cluster using these environment variables:

mongoexport 'mongodb+srv://cluster0.example.com/testdb?authSource=$external&authMechanism=MONGODB-AWS'  <other options>

Learn More

• mongoexport

• mongoexport Compatibility and Installation

• mongoexport Behavior