MongoDB基础（五）备份还原与导出导入 - 数据库编程

for stdin restore options: --drop drop each collection before import --writeConcern= write concern options e.g. --writeConcern majority, --writeConcern '{w: 3, wtimeout: 500, fsync: true, j:true}' (defaults to 'majority') --noIndexRestore don't restore indexes --noOptionsRestore don't restore collection options --keepIndexVersion don't update index version --maintainInsertionOrder preserve order of documents during restoration -j, --numParallelCollections= number of collections to restore in parallel (4 by default) --numInsertionWorkersPerCollection= number of insert operations to run concurrently per collection (1 by default) --stopOnError stop restoring if an error is encountered on insert (off bydefault)

3. 使用mongoimport 和 mongoexport

3.1 mongoexport导出

--type: 为json 或 csv
--fields: 选择导出的列


#导出列{_id,id,size}为csv的格式
mongoexport --db test --collection tab --type=csv --fields _id,id,size --out /root/test_tab.csv

#导出json格式
mongoexport --db test --collection tab --type=json --out /root/test_tab.json

#输出到shell中，查询id=2 并按name升序输出
mongoexport --db test --collection tab --query '{"id": 2}' --sort '{"name": 1}'

#查询导出
mongoexport --db test --collection tab --type=csv --query '{"id": 2}' --fields _id,id --out /root/test_tab.csv

#简写选项[--db]和[--collection]，使用跳过和限制函数输出
mongoexport -d test -c tab --sort '{"name": -1}' --limit 2 --skip 2 --out /root/test_tab.json


#若是远程，需要添加参数：host，port，username，password
--host servername_or_ip --port 37017 --username user --password pass

查看帮助：mongoexport --help

general options:
      --help                         print usage
      --version                      print the tool version and exit

verbosity options:
  -v, --verbose                      more detailed log output (include multiple times for more verbosity, e.g. -vvvvv)
      --quiet                        hide all log output

connection options:
  -h, --host=                        mongodb host to connect to (setname/host1,host2 for replica sets)
      --port=                        server port (can also use --host hostname:port)

ssl options:
      --ssl                          connect to a mongod or mongos that has ssl enabled
      --sslCAFile=                   the .pem file containing the root certificate chain from the certificate authority
      --sslPEMKeyFile=               the .pem file containing the certificate and key
      --sslPEMKeyPassword=           the password to decrypt the sslPEMKeyFile, if necessary
      --sslCRLFile=                  the .pem file containing the certificate revocation list
      --sslAllowInvalidCertificates  bypass the validation for server certificates
      --sslAllowInvalidHostnames     bypass the validation for server name
      --sslFIPSMode                  use FIPS mode of the installed openssl library

authentication options:
  -u, --username=                    username for authentication
  -p, --password=                    password for authentication
      --authenticationDatabase=      database that holds the user's credentials
      --authenticationMechanism=     authentication mechanism to use

namespace options:
  -d, --db=                          database to use
  -c, --collection=                  collection to use

output options:
  -f, --fields=                      comma separated list of field names (required for exporting CSV) e.g. -f "name,age"
      --fieldFile=                   file with field names - 1 per line
      --type=                        the output format, either json or csv (defaults to 'json')
  -o, --out=                         output file; if not specified, stdout is used
      --jsonArray                    output to a JSON array rather than one object per line
      --pretty                       output JSON formatted to be human-readable

querying options:
  -q, --query=                       query filter, as a JS

MongoDB基础（五）备份还原与导出导入(二)