본문 바로가기

카테고리 없음

mongo DB basic command

반응형

Start mongoDB daemon
> nohup mongod --bind-ip <ip> &
or >sudo service mongodb start

Shut Down 
>mongod --shutdown

show dbs
show tables

use <dbname>

db.dropDatabase()

db.<tableName>.find()

netstat -nlp | grep mongo 
(mongodb uses port 27017, 27186)

Remove lock file.
sudo rm /var/lib/mongodb/mongod.lock

Repair mongodb
sudo mongod --repair 

Check status of mongodb
> sudo status mongodb 
>sudo service mongodb status

Import json into mongodb
mongoimport -d <DB_name> -c <table_name> --file <file_name> --type json --host <host_ip> --port 27017

mongoimport -d opentarget -c evidence --file evi.json --type json --host 192.168.1.99 --port 27017

> db.evidence.createIndex({type: "hashed"})

{

"createdCollectionAutomatically" : false,

"numIndexesBefore" : 1,

"numIndexesAfter" : 2,

"ok" : 1

}

> db.evidence.createIndex({type:1})

{

"createdCollectionAutomatically" : false,

"numIndexesBefore" : 1,

"numIndexesAfter" : 2,

"ok" : 1

}

db.people.getIndexes()

 

> db.evidence.getIndexes()

[

{

"v" : 2,

"key" : {

"_id" : 1

},

"name" : "_id_",

"ns" : "opeddet.evidence"

},

{

"v" : 2,

"key" : {

"type" : 1

},

"name" : "type_1",

"ns" : "openddet.evidence"

}

]

> 

 

반응형