Database Management Systems
The MongoDB Database Tools include a utility called mongoexport that enables you to export MongoDB data to a CSV or JSON file.
One of the things you can do with this utitlity is export query results. This article shows you how to use mongoexport to export MongoDB query results to a JSON file.
The MongoDB Database Tools include a utility called mongoexport that enables you to export MongoDB data to a CSV or JSON file.
This article shows you how to use mongoexport to export a MongoDB collection to a JSON file.
The MongoDB Database Tools include a utility called mongoexport that enables you to export MongoDB data to a CSV or JSON file.
This article shows you how to use mongoexport to export a MongoDB collection to a CSV file.
If you have a view in a MongoDB database that you’d prefer to be a collection, you’re in the right place.
Below is an example of converting a view to a collection in MongoDB.
Continue readingIn MongoDB the db.collection.countDocuments() method returns the count of documents that match the query for a collection or view.
The collection part is the name of the collection or view to perform the count operation on.
In earlier versions of MongoDB, you could use the copyDB command or its helper method, db.copyDatabase() to copy a database.
MongoDB has since deprecated these. Also, starting in version 4.2, MongoDB has removed the copydb command, and therefore also the db.copyDatabase() method, which means that you can’t use them even if you wanted to if you’re using MongoDB 4.2 or later.
Fortunately, there’s another way to copy a MongoDB database.
Continue readingIn earlier versions of MongoDB, you could use the db.collection.copyTo() method to copy a collection.
MongoDB has since deprecated that method. Also, starting in version 4.2, MongoDB has removed the eval command. Given db.collection.copyTo() wraps eval, this means that you can’t use either of them if you’re using MongoDB 4.2 or later.
Fortunately, there’s another way to copy a MongoDB collection.
Continue readingIf you’ve backed up a database using the mongodump utility, you can restore it using the mongorestore utility.
The mongorestore utility loads data from either a binary database dump created by mongodump or the standard input into a mongod or mongos instance.
There are several ways to back up a database in MongoDB. One quick way to back up a database is to use the mongodump tool.
mongodump reads data from a MongoDB database and creates high fidelity BSON files which the mongorestore utitlity can use to restore a MongoDB database.
With mongodump, you can back up a collection, a database, or all databases.
In MongoDB, the distinct aggregation command finds the distinct values for a specified field across a single collection.
It returns a document that contains an array of the distinct values, as well as an embedded document with query statistics and the query plan.
Continue reading