Friday, January 2, 2015

MongoDB - Import


you can load data in the MongoDB via mongoimport utility

1) Make sure mongod is running

2) Create a file such as /apps/mongo/load.json

{name:{fn: 'Adarsh20',last: 'Kumar20'},loc:'A',ph:'20',state:['MO','VA','PA']}
{name:{fn: 'Adarsh10',last: 'Kumar10'},loc:'C',ph:'10',state:['CO','VA','CA']}
{name:{fn: 'Adarsh11',last: 'Kumar11'},loc:'D',ph:'11',state:['MO','VA','PA']}
{name:{fn: 'Adarsh14',last: 'Kumar14'},loc:'B',ph:'14',state:['BO','TA','PA']}
{name:{fn: 'Adarsh16',last: 'Kumar16'},loc:'Z',ph:'16',state:['MO','VA','AK']}
{name:{fn: 'Adarsh15',last: 'Kumar14'},loc:'H',ph:'15',state:['MO','KA','PA']}
{name:{fn: 'Adarsh18',last: 'Kumar18'},loc:'I',ph:'18',state:['TO','VA','MA']}
{name:{fn: 'Adarsh19',last: 'Kumar19'},loc:'E',ph:'19',state:['MO','VA','AA']}


3) goto mongo install directory and run the command

./mongoimport --db <dbname> --collection address --port <portname>  <  /apps/momgo/address.json

Example

on my Sandbox mongo is running at 20717 and I want the above data to be loaded in the emp databases's  address collection

./mongoimport --db emp --collection address --port 20717  <  /apps/momgo/address.json


4)  test using some

mongo node/dbname --port <port>

mongo  node1/emp --port 27017

>db.address.count()
8