How to copy a Database from a MongoDB instance to another?

16 Dec 2012

Some times we need to take backups or we need to copy databases to another server for administrative purposes. But sometimes just copying files is not enough. In MongoDB Shell, they support to copy the database from remote instance to the current one with a single command. ( :D Just like Single Click in Windows )

For this demo, I made alive two instances of MongoDB from the following commands.

# Instance 1  
mongod --port 9990 --dbpath /data/db1 

# Instance 2  
mongod --port 9991 --dbpath /data/db2

In instance 1 there is a database called “csampledb1”. For that, I need to connect to the first instance to create that database.

mongo localhost:9990

After that with the following commands, I create a database with one collection.

use csampledb1  
db.csamplecol1.save({id:1, name:"sample name"})

Then I log in to next MongoDB instance using MongoDB Shell.

mongo localhost:9991

Then I use a single command to copy the database from instance 1 to instance 2.

db.copyDatabase("csampledb1","csampledb2","localhost:9990")

Syntax of this function is like below. There are two arguments which I didn’t use.

db.copyDatabase(fromdb, todb, fromhost, username, password)

How to copy a Database from a MongoDB instance to another?

Tags