前言
上课时老师要求从CSV导入数据到MongoDB,这篇文章就具体介绍导入数据到MongoDB的详细过程(基于UBUNTU)。
过程
前提:安装好mongoimport
请注意,要导入的CSV,必须有标题,否则导入可能有问题。
导入命令如下:
mongoimport \
--uri "mongodb://username:password@localhost:27017" \
--collection users --type csv --file funds.csv --headerline
其中username处填写你数据库的用户名
password栏目填写你的对应的密码
localhost填写你服务器的IP地址
27017则是对应的端口
collections是目标集合
调用后结果如果结果跟下面类似则是数据集导入成功。
2025-10-12T13:20:36.290+0000 connected to: mongodb://[**REDACTED**]@localhost:27017/db1
2025-10-12T13:20:39.290+0000 [#.......................] db1.users 6.50MB/88.1MB (7.4%)
2025-10-12T13:20:42.290+0000 [###.....................] db1.users 13.2MB/88.1MB (15.0%)
2025-10-12T13:20:45.290+0000 [#####...................] db1.users 20.1MB/88.1MB (22.8%)
2025-10-12T13:20:48.294+0000 [#######.................] db1.users 26.6MB/88.1MB (30.2%)
2025-10-12T13:20:51.291+0000 [#########...............] db1.users 33.2MB/88.1MB (37.7%)
2025-10-12T13:20:54.291+0000 [##########..............] db1.users 39.7MB/88.1MB (45.1%)
2025-10-12T13:20:57.291+0000 [############............] db1.users 46.4MB/88.1MB (52.6%)
2025-10-12T13:21:00.290+0000 [##############..........] db1.users 53.0MB/88.1MB (60.2%)
2025-10-12T13:21:03.290+0000 [################........] db1.users 59.7MB/88.1MB (67.8%)
2025-10-12T13:21:06.290+0000 [##################......] db1.users 66.2MB/88.1MB (75.1%)
2025-10-12T13:21:09.291+0000 [###################.....] db1.users 72.7MB/88.1MB (82.5%)
2025-10-12T13:21:12.290+0000 [#####################...] db1.users 79.5MB/88.1MB (90.2%)
2025-10-12T13:21:15.290+0000 [#######################.] db1.users 86.1MB/88.1MB (97.7%)
2025-10-12T13:21:16.543+0000 [########################] db1.users 88.1MB/88.1MB (100.0%)
2025-10-12T13:21:16.544+0000 1158848 document(s) imported successfully. 0 document(s) failed to import.