Introduction to MongoDB

MongoDB is a popular open source Database application. While it is way easier than other databases, it also supports salient features like Master Slave replication, ad hoc queries, indexing and much more. Let us know few basic commands of MongoDB. You can login to MongoDB console with ‘mongo’ command.

1.   Check last ‘N’ entries
> db.collection.find().skip(db.collection.count() - N)

2.   Check the field and type in the collections
> db.collection.find()
 

3.   Find entry containing specific value in the field
   For only one entry - > db. collection.findOne({"messageText" : /.vaule./});
   For mulitple entries - > db. collection.find({messageText:/ .vaule./})
   For date specific entries > db. collection.find
( { $and: [ { messageText: { value } }, { messageText: { date-format-you have-entered } } ] } )

4.   Remove entry from mongodb (a document)
db.collectionname.remove({"_id": ObjectId("Object-ID-here")}
 

5.   Update the field value in the database
db. collection.update( { "_id": ObjectId("Object-ID-of-field-to-be-updated ")}, { $set: {"messageText": "field-with-updated-format"}})

6.   Find text in the collection/DB with pre-defined identifier
  General command - > db. collection.find( {}, { "identifier-value": "text-in-the-field" } )
  Restricting entries upto ‘N’ number - > db. collection.find( {}, { "identifier-value": "text-in-the-field" } )
.skip(db.collection.count() - N)

Commands to be executed outside MongoDB console i.e. Linux terminal

1.   Check which port is configured for MongoDB (mongoDB listening port)
# lsof -iTCP -sTCP:LISTEN | grep mongo
 

2.   Take complete backup of the MongoDB
  Complete backup - # mongodump  -o /path/to/take/dump
  Database specific backup - # mongodump --db newdb --out /path/to/take/dump/Name-of-backup

3.   Restore the complete mongoDB
# mongorestore /path/of/the/dump

 

  • 0 gebruikers vonden dit artikel nuttig
Was dit antwoord nuttig?

Gerelateerde artikelen

MongoDB Database Backups

This tutorial shows how to backup your GPUonCLOUD MongoDB database automatically using the Cron....

MSSQL

MSSQL Database Server Microsoft SQL Server is a relational DB management system, developed by...

MySQL/MariaDB Backup Scheduling

Using this instruction you can easily schedule the automatic backup of a MySQL or MariaDB...

PostgreSQL Database Replication

Database Replication with PostgreSQL 9 Replication is a basic technology for any database...

MariaDB Master Slave Replication

 MySQL/MariaDB Database Master-Slave Replication Master-slave replication is used to solve a...

Powered by WHMCompleteSolution