MongoDB数据处理：导出或导入_mongodbexport导出和navicat 导出有什么区别

mongoexport和mongoimport是mongodb提供的两个命令用于导出或导入数据，或者用于备份或恢复。数据格式可以是json或者csv。

一.mongoexport导出数据

使用语法

mongoexport <options>

常用参数

测试

## 以json标准格式导出
./mongoexport -d test -c test -v -h 172.16.0.105 --port=27017 -u zhangsan -p 123456 --authenticationDatabase test -o test.bat
2021-12-25T17:04:40.042+0800    connected to: 172.16.0.105:27017
2021-12-25T17:04:40.058+0800    exported 5 records

## 查看导出内容
cat test.bat
{"_id":{"$oid":"619b2f70e1d7962d1ec64fe6"},"title":"My First Post","date":{"$date":"2021-11-29T06:41:40.734Z"},"email":["lisi@123.com"]}
{"_id":{"$oid":"61a46b397f7e45efaa13b242"},"title":"My First Post","content":"Hello Word!!!","date":{"$date":"2021-11-29T05:54:54.622Z"},"conetent":"Hello Word!!!","email":[]}
{"_id":{"$oid":"61a47cdc7f7e45efaa13b243"},"type":4.0,"friut":"apple"}
{"_id":{"$oid":"61a47ceb7f7e45efaa13b244"},"type":2.0,"friut":"banana"}
{"_id":{"$oid":"61a47cfd7f7e45efaa13b245"},"type":2.0,"friut":"pear"}
1
2
3
4
5
6
7
8
9
10
11
12

##csv格式导出

./mongoexport -h 172.16.0.105 --port=27017 -u zhangsan -p 123456 --authenticationDatabase test -d test -c user -v --csv -f name,age,userid -o user.csv
2021-12-25T17:12:02.084+0800    csv flag is deprecated; please use --type=csv instead
2021-12-25T17:12:02.149+0800    connected to: 172.16.0.105:27017
2021-12-25T17:12:02.158+0800    exported 3 records

// 查看导出数据
cat user.csv
name,age,userid
zhangsan,18,1
lisi,19,2
wangwu,20,3
1
2
3
4
5
6
7
8
9
10
11
12
13

二.mongoimport导入数据

语法：

mongoimport <options> <file>

常用参数

测试

## 导入数据

./mongoimport -h 172.16.0.105 --port=27017 -u zhangsan -p 123456 --authenticationDatabase test -v -d test3 -c test3 test.bat
2021-12-30T09:28:40.210+0800    filesize: 526 bytes
2021-12-30T09:28:40.210+0800    using fields:
2021-12-30T09:28:40.249+0800    connected to: 172.16.0.105:27017
2021-12-30T09:28:40.249+0800    ns: test3.test3
2021-12-30T09:28:40.281+0800    connected to node type: standalone
2021-12-30T09:28:40.281+0800    using write concern: w='1', j=false, fsync=false, wtimeout=0
2021-12-30T09:28:40.281+0800    using write concern: w='1', j=false, fsync=false, wtimeout=0
2021-12-30T09:28:40.403+0800    imported 5 documents

// 查看插入数据情况
> db.test3.find()
{ "_id" : ObjectId("619b2f70e1d7962d1ec64fe6"), "title" : "My First Post", "date" : ISODate("2021-11-29T06:41:40.734Z"), "email" : [ "lisi@123.com" ] }
{ "_id" : ObjectId("61a46b397f7e45efaa13b242"), "title" : "My First Post", "content" : "Hello Word!!!", "date" : ISODate("2021-11-29T05:54:54.622Z"), "conetent" : "Hello Word!!!", "email" : [ ] }
{ "_id" : ObjectId("61a47cdc7f7e45efaa13b243"), "type" : 4, "friut" : "apple" }
{ "_id" : ObjectId("61a47ceb7f7e45efaa13b244"), "type" : 2, "friut" : "banana" }
{ "_id" : ObjectId("61a47cfd7f7e45efaa13b245"), "type" : 2, "friut" : "pear" }

// 以CSV方式导入
./mongoimport -d db_name -c tb_name --type csv --headerline --file aa.bat
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22