/ / / / / / MongoDB Export with $mongoexport
Are mongodb ids unique ?

MongoDB Export with $mongoexport

, , , , Edit
In the MongoDB, $mongoexport is used to take the backups of db tables (collections) in JSON, CSV and TSV format using the command.

 This command should be executed in the command prompt not in MongoDB clients.

MongoDB Export command options:

  -h <mongo-host-name>                    --This command is not required!
  -u <user-name>                                 --This command is not required!
  -p <password>                                   --This command is not required!
  -d <db-name>                                    --This command is required!
  -c <table-collection-name>             --This command is required!
  -f <table-fields>                                 --This command is not required!
  -q <query-filter>                                --This command is not Required, It is filter query.
  -o <out-file-format>         --This command is required! The output files (CSV, TSV or JSON)

MongoDB Export with $mongoexport

EXPORT ALL DOCUMENTS

$mongoexport -d myCustomersDB -c myCustomersCollection -o customers-backup.json

EXPORT ALL DOCUMENTS WITH SPECIFIC FIELDS

$mongoexport -d myCustomersDB -c myCustomersCollection -f "code,name,contactNo" -o customers-backup.json

RESULT FOR EXPORT DOCUMENTS FOR BOTH ABOVE QUERY

connected to: 127.0.0.1
exported 309751 records

For more https://docs.mongodb.com/master/reference/program/mongoexport/

ANIL SINGH

Anil Singh is an author, tech blogger, and software programmer. Book writing, tech blogging is something do extra and Anil love doing it. For more detail, kindly refer to this link..

My Tech Blog - https://www.code-sample.com/
My Books - Book 1 and Book 2

www.code-sample.com/. Powered by Blogger.
^