如何将bson和json文件导入MongoDB？

Question

如何将bson和json文件导入MongoDB？

3

我有以下来自https://github.com/Apress/def-guide-to-mongodb/tree/master/9781484211830/The%20Definitive%20Guide%20to%20MongoDB的bson和json文件。

$ ls .
aggregation.bson  aggregation.metadata.json  mapreduce.bson  mapreduce.metadata.json  storage.bson  text.json

如何将它们导入MongoDB？

我尝试将它们作为集合导入，但失败了：

$ 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，但上述命令是我在一本类似书籍中学到的示例。

谢谢。

更新

在下面的情况中，为什么第一个命令失败了而第二个成功了？我应该使用哪个命令？

$ 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

- Tim

1

你是否知道Mongo已经提供了命令行工具mongoexport，并且这可能会对你有所帮助。 - AliK

1个回答

网页内容由stack overflow 提供, 点击上面的

可以查看英文原文，
原文链接

- Acex · Accepted Answer

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文件夹里有这个文件吗？或者可能你使用的命令不完整？

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"
        ]
}