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