mongodb常用命令

集群搭建https://blog.csdn.net/kevinmcy/article/details/82712074

1.创建空文件注意点
将mkdir替换为touch，仅限创建空的文件
touch -p /home/mongodb/log/config.log
touch -p /home/mongodb/log/mongos.log
touch -p /home/mongodb/log/shard1.log
touch -p /home/mongodb/log/shard2.log
touch -p /home/mongodb/log/shard3.log

rs.initiate({_id:“configs”,members:[{_id:0,host:“192.168.23.132:27018”},{_id:1,host:“192.168.23.133:27018”}, {_id:2,host:“192.168.23.134:27018”}]})

rs.initiate({_id:“shard1”,members:[{_id:0,host:“192.168.23.132:27001”},{_id:1,host:“192.168.23.133:27001”},{_id:2,host:“192.168.23.134:27001”}]})

sh.addShard(“shard1/192.168.23.132:27001,192.168.23.133:27001,192.168.23.134:27001”)
sh.addShard(“shard2/192.168.23.132:27002,192.168.23.133:27002,192.168.23.134:27002”)
sh.addShard(“shard3/192.168.23.132:27003,192.168.23.133:27003,192.168.23.134:27003”)

2. db.status()
   db.user.getIndexes()
   db.user.findOne()
   db.user.stats()

db.qikegu.insert([
{
title: ‘MongoDB 入门’,
description: ‘MongoDB是一个以文档为中心的NOSQL数据库’,
by: ‘qikegu.com’,
url: ‘https://www.qikegu.com’,
tags: [‘mongodb’, ‘database’, ‘NoSQL’],
likes: 88
},

{
title: ‘MongoDB 优势’,
description: “MongoDB相对于RDBMS的优势”,
by: ‘qikegu.com’,
url: ‘https://www.qikegu.com’,
tags: [‘mongodb’, ‘database’, ‘NoSQL’],
likes: 89,
comments: [
{
user:‘user1’,
message: ‘My first comment’,
dateCreated: new Date(2018,11,10,2,35),
like: 0
}
]
}
])

3.按时间查询

db.xxx.find({“ct”:{KaTeX parse error: Expected 'EOF', got '}' at position 24: …Date(2016,11,1)}̲}) mongoDB对时间的处…gt":ISODate(“2017-04-20T01:16:33.303Z”)}}) // 大于某个时间

db.getCollection(‘CustomerBehaviorLog_0407’).
find({
CreateTime: {
$gte: ISODate(“2020-03-31T16:00:00.000Z”),
KaTeX parse error: Expected 'EOF', got '}' at position 45: …:00.000Z") }̲, "BehaviorType…in":[1,2]}
}).count();

4.按条件导出数据
mongoexport -u user -p pwd! -d dbName -c users -q ‘{age:20}’ -o /data/date.json
mongoexport -u user -p pwd! -d dbName -c users --type=csv -f _id,name,age -o /data/date.csv
导入数据
mongoimport -u user -p pwd -d dbName -c users --file /data/date.json
mongoimport -u user -p pwd -d dbName -c users --type=csv --headerline --file /data/date.csv

mongoimport -u admin -p admin -d admin -c customer_0303 --file customer_0303.json

mongoexport -h 182.254.150.218:27017 -u leyou -p leyou -d leyou -c CustomerBehaviorLog_0407 -q ‘{“CreateTime”:{$gte:ISODate("2020-03-30T16:00:00.000Z"),$lt: ISODate(“2020-03-31T16:00:00.000Z”)}}’ -o customer_0330.json
mongoexport -u admin -p admin -d admin -c CustomerBehaviorLog_1024 -q ‘{“CreateTime”:{“$gte":ISODate("2020-03-0306:22:56.580Z"),"$lte”:ISODate(“2020-03-04 06:22:56.580Z”)}}’ -o customer_0303.json
mongoexport -u admin -p admin -d admin -c CustomerBehaviorLog_1024 -q ‘{"_id":{“$gte":ObjectId("5e5df7c071ab8a1ce48eeae8"),"$lt”:ObjectId(“5e5f48f82ddbfa05f0ee3d9d”)}}’ -o customer_0303.json

5.建库、建表
use test2
db.createCollection(‘customer_0303’);