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.
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