MongoDB常用脚本备忘（一）

一、初始化环境和用户

rs.initiate({_id:'rs0',members:[{_id:1,host:'192.168.1.100:27017'}]});

#创建root账号
use admin;
db.createUser({
    user:"root",pwd:"123456",
    roles: [{role:"userAdminAnyDatabase",db:"admin"},{role:"root",db:"admin"}, "readWriteAnyDatabase" ]
});
db.auth("root","123456");


#创建普通账号
use proj_dev;
db.createUser({
    user:"proj",pwd:"123456",
    roles: [{role:"dbAdmin",db:"proj_dev"},{role:"readWrite",db:"proj_dev"}]
});
db.auth("proj","123456");

#授权
db.grantRolesToUser("proj",[{role:"dbAdmin",db:"proj_test"},{role:"readWrite",db:"proj_test"}]);

#查询所有用户
db.system.users.find().pretty();

#删除用户
db.system.users.remove({user:"proj"})

#修改密码
db.changeUserPassword('proj','123456789'); 

二、备份和恢复

Linux下备份
/usr/local/mongodb/bin/mongodump --port 27017 -d proj_dev -o ./proj_dev_20200101 -u proj -p 123456

Windows下备份
"C:/Program Files/MongoDB/Server/4.2/bin/mongodump" --host 192.168.1.100 --port 27017 -d proj_dev_20200101 -o ./proj_dev_20200101 -u proj -p 123456


Linux下恢复
/usr/local/mongodb/bin/mongorestore -u proj -h localhost:27017 -d proj_dev  /mdata/sql/proj_dev_20200101/proj_dev/


Windows下恢复
"C:/Program Files/MongoDB/Server/4.2/bin/mongorestore" -u proj -p 123456 -h 192.168.1.100:27017 -d proj_dev "D:/backup/mongodb/proj_dev_20200101/proj_dev/"

MongoDB常用脚本备忘（一）

原文：https://www.cnblogs.com/huligong1234/p/12489766.html