如何将bson和json文件导入MongoDB? [英] How can I import bson and json files into MongoDB?

问题描述

我从如何将它们导入MongoDB?

How can I import them into MongoDB?

我尝试将每个导入为一个集合，但是失败了:

I tried to import each of them as a collection, but failed:

$ mongorestore -d test -c aggregation 
2018-07-18T01:44:25.376-0400    the --db and --collection args should only be used when restoring from a BSON file. Other uses are deprecated and will not exist in the future; use --nsInclude instead
2018-07-18T01:44:25.377-0400    using default 'dump' directory
2018-07-18T01:44:25.377-0400    see mongorestore --help for usage information
2018-07-18T01:44:25.377-0400    Failed: mongorestore target 'dump' invalid: stat dump: no such file or directory

我不确定是否正确指定文件aggregation.bson，但是上面的命令是我从书中类似示例中学到的.

I am not sure if I specify the file aggregation.bson correctly, but the above command is what I learned from a similar example in a book.

谢谢.

更新

在下面，为什么第一次失败而第二次成功?我应该使用哪个命令?

In the following, why did the first fail and the second succeed? Which command shall I use?

$ mongoimport -d test -c aggregation --file aggregation.bson 
2018-07-18T09:45:44.698-0400    connected to: localhost
2018-07-18T09:45:44.720-0400    Failed: error processing document #1: invalid character 'º' looking for beginning of value
2018-07-18T09:45:44.720-0400    imported 0 documents

$ mongoimport -d test -c aggregation --file aggregation.metadata.json 
2018-07-18T09:46:05.058-0400    connected to: localhost
2018-07-18T09:46:05.313-0400    imported 1 document

推荐答案

mongoimport --db dbName --collection collectionName --type json --file fileName.json

---

更新:

C:\Program Files\MongoDB\Server\4.0\bin>mongorestore -d test -c aggregation aggregation.bson
2018-07-19T10:28:39.963+0300    checking for collection data in aggregation.bson
2018-07-19T10:28:40.099+0300    restoring test.aggregation from aggregation.bson
2018-07-19T10:28:41.113+0300    no indexes to restore
2018-07-19T10:28:41.113+0300    finished restoring test.aggregation (1000 documents)
2018-07-19T10:28:41.113+0300    done

所以我尝试了一下，它对我来说很好用，是您的bin文件夹中有文件，还是您使用的命令未完成?

So I tried it and it worked fine for me do you have the file in your bin folder or maybe the command you used wasn't complete?

db.aggregation.find().pretty().limit(2)                                                                               
{
        "_id" : ObjectId("51de841747f3a410e3000001"),
        "num" : 1,
        "color" : "blue",                                                                                                       
        "transport" : "train",
        "fruits" : [
                "orange",
                "banana",
                "kiwi"
        ],
        "vegetables" : [
                "corn",
                "broccoli",
                "potato"
        ]
}
{
        "_id" : ObjectId("51de841747f3a410e3000005"),
        "num" : 5,
        "color" : "yellow",
        "transport" : "plane",
        "fruits" : [
                "lemon",
                "cherry",
                "dragonfruit"
        ],
        "vegetables" : [
                "mushroom",
                "capsicum",
                "zucchini"
        ]
}

这篇关于如何将bson和json文件导入MongoDB?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！