mongodb命令查詢所有數(shù)據(jù)庫列表

MongoDb2012-07-1409:23:07|分類：mongodb||字號訂MongoDbshowtestuseswitchedtodbtestcollection，可以輸入showmongodbhelpDos代碼show showdatabaseshow showcollectionsincurrentshow showusersincurrentshowprofile fileentrieswithtime>=1msuse<db setcurentdatabaseto<db helponDB helponcollection listobjectsincollectionfoodb.foo.find({a:1}) listobjectsinfoowherea==1 resultofthelastlineevaluated;usetofurtheri fileentrieswithtime>=1msuse<dbname>setcurentdatabaseto<dbname>helponDBmethodshelponcollectionmethodslistobjectsincollectionfoodb.foo.find({a:1})listobjectsinfoowherea== resultofthelastlineevaluated;usetofurtheriJavaDBdb.addUser(username,password)添加數(shù)據(jù)庫 db.auth(username,password) db.cloneDatabase(fromhost)克隆數(shù)據(jù)庫mandHelp(name)returnsthehelpforthecommanddb.copyDatabase(fromdb,todb,fromhost) db.createCollection(name,sizecappedmax創(chuàng)db.currentOp()disysthecurrentoperationinthedb db.eval_r(func,args)runcodeserver-sidedb.getCollection(cname)sameasdb['cname']or db.getLastError()-justreturnstheerrmsgstringdb.getLastErrorObj()-returnfullstatusobjectdb.getMongo()gettheserverconnectionobjectdb.getMongo().setSlaveOk()allowthisconnectiontoreadthenonmastermemberofareplicapairdb.getSisterDB(name)getthedbatthesameserverasthiswdb.killOp()killsthecurrentoperationinthedb 息 db.removeUser(username)刪除數(shù)據(jù)庫用戶db.repairDatabase()修復數(shù)據(jù)庫mand(cmdObj)runadatabasecommand.ifjisastring,turnsitinto{cmdObj:1}db.setProfilingLevel(level)0=off1=slow2=alldb.version()currentversionoftheDBdb.addUser(username,password)添加數(shù)據(jù)庫用戶db.auth(username,password) db.cloneDatabase(fromhost)克隆數(shù)據(jù)庫mandHelp(name)returnsthehelpforthedb.copyDatabase(fromdb,todb,fromhost)數(shù)據(jù)db.createCollection(name,{size:...,capped:...,max:...}db.currentOp()disysthecurrentoperationinthedb db.eval_r(func,args)runcodeserver-sidedb.getCollection(cname)sameasdb['cname']or db.getLastError()-justreturnstheerrmsgstringdb.getLastErrorObj()-returnfullstatusobjectdb.getMongo()gettheserverconnectionobjectdb.getMongo().setSlaveOk()allowthisconnectiontoreadfromthenonmastermemberofareplicapairdb.getSisterDB(name)getthedbatthesameserverasthisonewdb.killOp()killsthecurrentoperationinthedb db.removeUser(username)db.repairDatabase()修復數(shù)據(jù)庫mand(cmdObj)runadatabasecommand. ifcmdObjisastring,turnsitinto{cmdObj:1}db.setProfilingLevel(level)0=off1=slow2=alldb.version()currentversionofthecollection支持哪些方法，可以使用一下 userJavaDBCollection db.foo.distinct(key)-eg.db.foo.distinct('x') db.foo.dropdropthecollection刪除表db.foo.dropIndex(name)刪除指定索引db.foo.dropIndexes()刪除所有索引db.foo.ensureIndex(keypattern,options)-optionsshouldbeanbjectwiththesepossiblefieldsnameuniquedropDupsdb.foo.find([query],[fields])-firstparameterisanoptionalqueryfilter.secondparameterisoptionalsetoffieldstoreturn.DBCollection db.foo.distinct(key)-eg.db.foo.distinct('x') db.foo.drop()dropthecollection刪除表 db.foo.dropIndexes()刪除 db.foo.ensureIndex(keypattern,options)-optionsshouldbeanobjectwiththesepossiblefields:name,unique, db.foo.find([query],[fields])-firstparameterisanoptionalqueryfilter.secondparameterisoptionalsetoffieldstoreturn.通過條件查詢：db.foo.findx77name1x1db.foo.find(...).limit(n)db.foo.find(...).sort(...)db.foo.findOne([query])db.foo.getDB()getDBobjectassociatedwithcollection db.foo.getIndexes()db.foo.groupkeyinitial:reducecond:...]})根據(jù)db.foo.mapReduce(mapFunction,reduceFunction,<optionalparams>)db.foo.remove(query)db.foo.renameCollection(newNamerenamesthe db.foo.save(obj) db.foo.storageSize()-includesspaceallocatedtothiscollection查詢分配到表空間大小db.foo.totalIndexSize()sizeinbytesofalltheindexes查詢所db.foo.totalSize()-storageallocatedforalldataanddb.foo.update(queryobject[upsert_bool])根據(jù)條件更新數(shù)據(jù)db.foo.validate()-SLOW驗證表的詳細信息db.foo.getShardVersion()-onlyforusewithshardingMongodbmongodumptest如： ~/mongodb/bin]$./mongodump--help producehelp-h[--host] mongohosttoconnect-d[--db] databaseto-c[--collection] collectiontouse(some-u[--username] -p[--password] --dbpatharg directlyaccessmongoddatafilesinthisinsteadofconnectingtoamongod-v[--verbose] bemoreverbose(includemultipletimesforverbositye.g.--o[--out]arg(=dump)output ~/mongodb/bin]$./mongodump-dtest-otest/connectedto:DATABASE:test test.usertotest/test/user.bson100000test.system.indexesto ~/mongodb/bin]$ MongoDBmongorestoretestshowcollectionsusershowcollections ~/mongodb/bin]$./mongorestore--helpusage:./mongorestore[options][directoryorfilenametorestore producehelp-h[--host] mongohosttoconnect-d[--db] databaseto-c[--collection]argcollectiontouse(some-u[--username] -p[--password] --dbpatharg directlyaccessmongoddatafilesinthisinsteadofconnectingtoamongod-v[--verbose] bemoreverbose(includemultipletimesforverbositye.g.- ~/mongodb/bin]$./mongorestore-d-cusertest/test/user.bsonconnectedto:goingintonamespace[test.user]100000objectsUser10wshow{"_id":ObjectId("4b9c8db08ead0e "),"uid":1,"username":"Falcon.C-1"}{"_id":ObjectId("4b9c8db08ead0e "),"uid":2,"username":"Falcon.C-2"}{"_id":Objec