mongoDB备份恢复数据库

mongodb 创建用户

• use augmarketing (选择数据库)
• show users (查看当前数据库的用户及roles)

• 使用createUser创建mongodb的用户

  db.createUser({user:"user",pwd: "abc123_",roles: ["readWrite","dbAdmin"]});

• show users (查看创建情况)

    {
      "_id" : "augmarketing.root",
      "user" : "root",
      "db" : "augmarketing",
      "roles" : [
        {
          "role" : "readWrite",
          "db" : "augmarketing"
        },
        {
          "role" : "dbAdmin",
          "db" : "augmarketing"
        }
      ]
    }

备份数据库

mongodump --host yourHostIp --port 27017 --db augmarketing --username aug --password abc123_ --out /home/user/monogodb/wm

refer to: mongodump

恢复数据库

mongorestore --host 127.0.0.1 --port 27017 --db wm --username root --password root /home/user/monogodb/wm/augmarketing

refer to: mongorestore

查询语句

• 查询全部

    db.getCollection('user').find();

• $in 查询

    db.getCollection('user').find({
      'name' : {
        $in: ['xx', 'xx']
      }
    });