MongoDB单表导出与导入

mongoexport -h 192.168.6.66 --port -u dbAdmin -p L-$LpGQ=FJvSf*****([l --authenticationDatabase=project_core_db -d project_core_db -c TradeRecordDetail -o D:/TradeRecordDetail.jsonmongoimport -h 127.0.0.1 --port -u root -p --authenticationDatabase=admin -d test -c TradeRecordDetail --upsert --drop D:/TradeRecordDetail.json

mongodump -h 127.0.0.1: -u root -p --authenticationDatabase=admin -d test -o D:/mongo/dumpmongorestore -h 127.0.0.1: -u root -p --authenticationDatabase=admin -d project_core_db D:\mongo\dump\project_core_db

> use admin
switched to db admin
> db.auth('root','')
> use project_core_db
switched to db project_core_db
> db.createUser({user:'hanli',pwd:'hanli',roles:[{role:'dbAdmin',db:'project_core_db'}]})
Successfully added user: {
"user" : "hanli",
"roles" : [
{
"role" : "dbAdmin",
"db" : "project_core_db"
}
]
}
>

use admin
创建超级管理员
db.createUser(
{
user:"root",
pwd:"82xo#F*N6LC(vWwC",
roles:["root"]
}
)
db.auth('root','82xo*N6LC(vWwC')
use project_core_db
创建正式库读写用户
db.createUser(
{
user:"customer",
pwd:"q=%bJ~*!PhfHG",
roles:[{role:"readWrite",db:"project_core_db"}]
}
)
创建正式库运维用户
db.createUser(
{
user:"dbAdmin",
pwd:"L-$LpGQ=F**RsFHI.$([l",
roles:[{role:"dbAdmin",db:"project_core_db"},{role:"readWrite",db:"project_core_db"}]
}
)