3,使用mongoexport导出数据

1,下载MongoDB数据库工具

https://www.mongodb.com/try/download/database-tools

注意:
    从MongoDB 4.4开始，MongoDB数据库工具单独发布，使用自己的版本，初始版本为100.0.0
    
    目前最新的版本为100.3.1,其支持如下版本:
    MongoDB 5.0
    MongoDB 4.4
    MongoDB 4.2
    MongoDB 4.0
    MongoDB 3.6

2,安装

1,可以下载.msi或zip包
2,如果是zip,需要解压到某个目录,并将其配置到系统环境变量里面

3,启动mongo服务

mongod.exe --dbpath D:\UserData\mongodb --auth

4,批量导入数据

cd D:\DevelopmentTool\mongodb-win32-x86_64-windows-5.0.0\tool
mongoexport --authenticationDatabase=admin --username admin --password 123456 --uri="mongodb://127.0.0.1:27017/test"  --collection=book  --out=D:\UserData\Administrator\Desktop\book1.crud.json
或
mongoexport --authenticationDatabase=admin  --uri="mongodb://admin:123456@127.0.0.1:27017/test"  --collection=book  --out=D:\UserData\Administrator\Desktop\book2.crud.json
或
mongoexport --authenticationDatabase=admin --username admin --password 123456 --host="127.0.0.1:27017" --collection=book --db=test --out=D:\UserData\Administrator\Desktop\book3.crud.json
或
mongoexport --authenticationDatabase=admin --username admin --password 123456 --host="127.0.0.1" --port=27017 --collection=book --db=test --out=D:\UserData\Administrator\Desktop\book4.crud.json

说明:
    --db test 将数据存入test库
    --collection book 将数据存入book集合
    --authenticationDatabase admin --username admin --password 123456  使用admin和123456进行登录
    --drop 如果集合存在,就删除
    --file D:\UserData\Administrator\Desktop\book.crud.json 指定导入的数据文件
    
# 导出的文件内容
{"_id":{"$oid":"60ef8c98c5f621a583c6afb1"},"item":"journal","qty":25,"size":{"h":14,"w":21,"uom":"cm"},"status":"A"}
{"_id":{"$oid":"60ef8c98c5f621a583c6afb2"},"item":"paper","qty":100,"size":{"h":8.5,"w":11,"uom":"in"},"status":"D"}
{"_id":{"$oid":"60ef8c98c5f621a583c6afb3"},"item":"postcard","qty":45,"size":{"h":10,"w":15.25,"uom":"cm"},"status":"A"}
{"_id":{"$oid":"60ef8c98c5f621a583c6afb4"},"item":"notebook","qty":50,"size":{"h":8.5,"w":11,"uom":"in"},"status":"A"}
{"_id":{"$oid":"60ef8c98c5f621a583c6afb5"},"item":"planner","qty":75,"size":{"h":22.85,"w":30,"uom":"cm"},"status":"D"}