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

ON string, e.g., '{x:{$gt:1}}' -k, --slaveOk allow secondary reads if available (default true) --forceTableScan force a table scan (do not use $snapshot) --skip= number of documents to skip --limit= limit the number of documents to export --sort= sort order, as a JSON string, e.g. '{x:1}'

3.2 mongoimport 导入

#列"_id"也会导入，注意重复键
mongoimport --db mydb --collection tab --file /root/test_tab.json

mongoimport --db mydb --collection tab --type csv --headerline --file /root/test_tab.csv


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

查看帮助： mongoimport --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

input options:
  -f, --fields=                      comma separated list of field names, e.g. -f name,age
      --fieldFile=                   file with field names - 1 per line
      --file=                        file to import from; if not specified, stdin is used
      --headerline                   use first line in input source as the field list (CSV and TSV
                                     only)
      --jsonArray                    treat input source as a JSON array
      --type=                        input format to import: json, csv, or tsv (defaults to 'json')

ingest options:
      --drop                         drop collection before inserting documents
      --ignoreBlanks                 ignore fields with empty values in CSV and TSV
      --maintainInsertionOrder       insert documents in the order of their appearance in the input source
  -j, --numInsertionWorkers=         number of insert operations to run concurrently (defaults to 1)
      --stopOnError                  stop importing at first insert/upsert error
      --upsert                       insert or update objects that already exist
      --upsertFields=                comma-separated fields for the query part of the upsert
      --writeConcern=                write concern options e.g. --writeConcern majority,
                                     --writeConcern '{w: 3, wtimeout: 500, fsync: true, j: true}'
                                     (defaults to 'majority')

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