MongoDB备份与恢复(2)—数据导入mongoimport

henryjia

1、概述

Mongodb中mongoimport命令可以把指定的格式文件导入到指定的集合中，既可以导入JSON格式数据也可以导入CSV格式数据。

2、帮助命令-help

可以使用help命令查看Mongoimport的帮助信息，命令操作如下：

<code>[root@ggtest1 ~]# mongoimport --help
Usage:
  mongoimport <options> <file>
Import CSV, TSV or JSON data into MongoDB. If no file is provided, mongoimport reads from stdin.
See http://docs.mongodb.org/manual/reference/program/mongoimport/ 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)
kerberos options:
      --gssapiServiceName=<service-name>          service name to use when authenticating using GSSAPI/Kerberos ('mongodb' by default)
      --gssapiHostName=<host-name>                hostname to use when authenticating using GSSAPI/Kerberos (remote server's address by
                                                  default)
ssl options:
      --ssl                                       connect to a mongod or mongos that has ssl enabled
      --sslCAFile=<filename>                      the .pem file containing the root certificate chain from the certificate authority
      --sslPEMKeyFile=<filename>                  the .pem file containing the certificate and key
      --sslPEMKeyPassword=<password>              the password to decrypt the sslPEMKeyFile, if necessary
      --sslCRLFile=<filename>                     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>                       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
input options:
  -f, --fields=<field>[,<field>]*                 comma separated list of field names, e.g. -f name,age
      --fieldFile=<filename>                      file with field names - 1 per line
      --file=<filename>                           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=<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>              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=<field>[,<field>]*           comma-separated fields for the query part of the upsert
      --writeConcern=<write-concern-specifier>    write concern options e.g. --writeConcern majority, --writeConcern '{w: 3, wtimeout: 500,
                                                  fsync: true, j: true}' (defaults to 'majority')
      --bypassDocumentValidation                  bypass document validation
[root@ggtest1 ~]#
</code>

本帖部分内容已隐藏，请登入并回覆，以查看隐藏内容！

yea

最近在匯入 csv 檔案，很實用~ 收藏~

neo

想請問一下，並沒有指定欄位的分隔符號是用‘，‘或是tab區隔？

另外經常遇到的一個問題就是在特定的資料可能會有某個欄位的資料跟分隔符號相同

此時的情況是整個批次作業會完成．但是把哪筆資料排除

還是說整個批次作業會取消

或者是就停在出錯的哪筆資料不往下進行匯入

如果是最後一種．是否會紀錄匯入到哪筆資料?

yea

@neo

在這篇有討論過，基本上就是要先對文件內容做字串處理，再使用 mongoimport 匯入

http://forum.foxera.com/mongodb/topic/467/mongodb怎样导入固定分隔符文本文件内容

zhouhhh

helloworld mongodb

PlantWang

open it soon