• mongodb 备份 指定用户名密码


    正确备份语句:   mongodump -h 172.27.137.26:36137 -d ssdb -o f:datassdb170505 -u=administrator -p=qqddd.222 --authenticationDatabase=admin
     
     
    第一次使用 mongodump -h 172.27.137.26:36137 -d ssdb -o f:datassdb170505 -u=administrator -p=qqddd.222
    当备份时报错: 

    Failed: error connecting to db server: server returned error on SASL authentication step: Authentication failed.

    需要添加--authenticationDatabase admin

    mongodump --help 所有参数:

    Usage:
    mongodump <options>
     
    Export the content of a running server into .bson files.
     
    Specify a database with -d and a collection with -c to only dump that database or collection.
     
    See http://docs.mongodb.org/manual/reference/program/mongodump/ for more information.
     
    general options:
    --help print usage
    --version print the tool version and exit
     
    verbosity options:
    -v, --verbose=<level> more detailed log output (include multiple times for more verbosity, e.g. -vvvvv, or specify a numeric value, e.g. --verbose=N)
    --quiet hide all log output
     
    connection options:
    -h, --host=<hostname> mongodb host to connect to (setname/host1,host2 for replica sets)
    --port=<port> server port (can also use --host hostname:port)
     
    authentication options:
    -u, --username=<username> username for authentication
    -p, --password=<password> password for authentication
    --authenticationDatabase=<database-name> database that holds the user's credentials
    --authenticationMechanism=<mechanism> authentication mechanism to use
     
    namespace options:
    -d, --db=<database-name> database to use
    -c, --collection=<collection-name> collection to use
     
    query options:
    -q, --query= query filter, as a JSON string, e.g., '{x:{$gt:1}}'
    --queryFile= path to a file containing a query filter (JSON)
    --readPreference=<string>|<json> specify either a preference name or a preference json object
    --forceTableScan force a table scan
     
    output options:
    -o, --out=<directory-path> output directory, or '-' for stdout (defaults to 'dump')
    --gzip compress archive our collection output with Gzip
    --repair try to recover documents from damaged data files (not supported by all storage engines)
    --oplog use oplog for taking a point-in-time snapshot
    --archive=<file-path> dump as an archive to the specified path. If flag is specified without a value, archive is written to stdout
    --dumpDbUsersAndRoles dump user and role definitions for the specified database
    --excludeCollection=<collection-name> collection to exclude from the dump (may be specified multiple times to exclude additional collections)
    --excludeCollectionsWithPrefix=<collection-prefix> exclude all collections from the dump that have the given prefix (may be specified multiple times to exclude additional prefixes)
    -j, --numParallelCollections= number of collections to dump in parallel (4 by default)
     
  • 相关阅读:
    前后端分离ssm配置跨域
    springboot结合MyBatis中使用foreach
    springboot结合全局异常处理之登录注册验证
    SpringBoot整合shiro从初恋到失恋
    IDEA热布署报错java.lang.IllegalStateException: Restarter has not been initialized
    SpringBoot启动报错Failed to determine a suitable driver class
    Navicat连接远程数据库报1251的错误
    git远程易错点
    数组中出现次数超过一半的数
    二叉树中两个节点的最近公共祖先
  • 原文地址:https://www.cnblogs.com/ssjsk/p/6812334.html
Copyright © 2020-2023  润新知