MongoDB 数据库操作（七）-数据导入

来源：互联网发布：sql注入测试工具编辑：程序博客网时间：2024/05/03 09:14

1.Json数据导入

为了展示，先将things数据库删掉:

> db.things.drop();true> show collectionsfs.chunksfs.filesresultsystem.indexessystem.js

之后进行数据导入；

./mongoimport -d test -c things /data/mongodb/things.out

结果：

> show collectionsfs.chunksfs.filesresultsystem.indexessystem.jsthings> db.things.find();{ "_id" : ObjectId("5159040c7cdde2222d5ae73f"), "name" : "mongo" }{ "_id" : ObjectId("51590688779db544eb8dfffa"), "x" : 0, "y" : 0 }{ "_id" : ObjectId("51590688779db544eb8dfffb"), "x" : 1, "y" : 1 }{ "_id" : ObjectId("51590688779db544eb8dfffc"), "x" : 2, "y" : 4 }{ "_id" : ObjectId("51590688779db544eb8dfffd"), "x" : 3, "y" : 9 }{ "_id" : ObjectId("51590688779db544eb8dfffe"), "x" : 4, "y" : 16 }{ "_id" : ObjectId("51590688779db544eb8dffff"), "x" : 5, "y" : 25 }{ "_id" : ObjectId("51590688779db544eb8e0000"), "x" : 6, "y" : 36 }{ "_id" : ObjectId("51590688779db544eb8e0001"), "x" : 7, "y" : 49 }{ "_id" : ObjectId("51590688779db544eb8e0002"), "x" : 8, "y" : 64 }{ "_id" : ObjectId("51590688779db544eb8e0003"), "x" : 9, "y" : 81 }{ "_id" : ObjectId("5159f345779db544eb8e0004"), "name" : "x", "age" : null }{ "_id" : ObjectId("5159f6f3779db544eb8e0005"), "name" : "yy", "arr" : [ 1, 2, 3                                                                       , 4, 5, 67 ] }{ "_id" : ObjectId("5159f70a779db544eb8e0006"), "name" : "yy", "arr" : [ 1, 2, 3                                                                       , 4 ] }

2.导入CSV格式数据

命令：

./mongoimport -d test -c things2 --type csv --headerline --file /data/mongodb/things.out1

参数说明:
-type 指明要导入的文件格式
-headerline 批明不导入第一行，因为第一行是列名
-file 指明要导入的文件路径

首先看一下things.out1的内容：

cat things.out1_id,x,yObjectID(5159040c7cdde2222d5ae73f),,ObjectID(51590688779db544eb8dfffa),0.0,0.0ObjectID(51590688779db544eb8dfffb),1.0,1.0ObjectID(51590688779db544eb8dfffc),2.0,4.0ObjectID(51590688779db544eb8dfffd),3.0,9.0ObjectID(51590688779db544eb8dfffe),4.0,16.0ObjectID(51590688779db544eb8dffff),5.0,25.0ObjectID(51590688779db544eb8e0000),6.0,36.0ObjectID(51590688779db544eb8e0001),7.0,49.0ObjectID(51590688779db544eb8e0002),8.0,64.0ObjectID(51590688779db544eb8e0003),9.0,81.0ObjectID(5159f345779db544eb8e0004),,ObjectID(5159f6f3779db544eb8e0005),,ObjectID(5159f70a779db544eb8e0006),,

之后看一下things2的内容：

 db.things2.find();{ "_id" : "ObjectID(5159040c7cdde2222d5ae73f)", "x" : "", "y" : "" }{ "_id" : "ObjectID(51590688779db544eb8dfffa)", "x" : 0, "y" : 0 }{ "_id" : "ObjectID(51590688779db544eb8dfffb)", "x" : 1, "y" : 1 }{ "_id" : "ObjectID(51590688779db544eb8dfffc)", "x" : 2, "y" : 4 }{ "_id" : "ObjectID(51590688779db544eb8dfffd)", "x" : 3, "y" : 9 }{ "_id" : "ObjectID(51590688779db544eb8dfffe)", "x" : 4, "y" : 16 }{ "_id" : "ObjectID(51590688779db544eb8dffff)", "x" : 5, "y" : 25 }{ "_id" : "ObjectID(51590688779db544eb8e0000)", "x" : 6, "y" : 36 }{ "_id" : "ObjectID(51590688779db544eb8e0001)", "x" : 7, "y" : 49 }{ "_id" : "ObjectID(51590688779db544eb8e0002)", "x" : 8, "y" : 64 }{ "_id" : "ObjectID(51590688779db544eb8e0003)", "x" : 9, "y" : 81 }{ "_id" : "ObjectID(5159f345779db544eb8e0004)", "x" : "", "y" : "" }{ "_id" : "ObjectID(5159f6f3779db544eb8e0005)", "x" : "", "y" : "" }{ "_id" : "ObjectID(5159f70a779db544eb8e0006)", "x" : "", "y" : "" }

更详细的信息用mongoimport -help命令来查看。