MongoDB 2.4 has been released. MongoDB 2.4 is the latest stable release, following the September 2012 release of MongoDB 2.2. The MongoDB 2.4 release contains key new features along with performance improvements and bug fixes. Here are the highlights…

MongoDB ships with a web-based administrative tool. You can see this tool by going to http://localhost:28017/ You can see a bunch of stuff on this screen. However when trying any of these on top List all commands | Replica set status Command…

In a regular SQL database, you can check if a column is null by using IS NULL For example if you wanted to return all rows where the age is null, you would do the following SELECT * FROM SomeTable WHERE age IS NULL In a NoSQL database it is po…

Let's say you have a collection and you are only interested in storing the last 50 items or so. Everytime you add a new item, you want the oldest item to disappear. What you can do is create a capped collection. Here are some behaviors that capped colle…

In this post we are going to look at how to drop database and collections. We already covered backup and restores, now that you know how to do that, it is safe to cover dropping collections and databases Execute the following command, it will create…

In this post we are going to take a look at how to export data into files. We are going to export data in json format as well as in csv format. To get started first connect to mongodb and create a new database named ExportDB You can just execute the…

We looked at how to backup and restore databases in the post MongoDB: How to backup and restore databases. We also looked at how to restore collection in the post MongoDB: How to restore collections. Today we are going to look at how to backup all the d…

In yesterday's post MongoDB: How to backup and restore databases we looked at how to backup and restore a database, today we are going to look at how to restore a collection from a backup. Be aware that mongorestore and mongodump have to be executed fro…

Today it is time to learn how to backup and restore databases in MongoDB. You do have jobs setup that automatically create backups right? If you do not, please close this window and go set that up first, your data is the most important part of the organ…

In this post we are going to take a look at how to limit results in MongoDB as well how to page through results. MongoDB use limit to limit the number of results return, MongoDB use skip to skip a number of records from the results set. Using limit in c…