首页 > 数据库 > NoSQL > mongoexport和mongoimport实战
1、mongoexport导出csv文件
mongoexport --host 172.16.254.130 --port 27017 -u admin --authenticationDatabase admin -d db6 -c db6 --type csv -f 'name,name1,name2,name3' -o /mongodb/backup/db6.csv Enter password: 2021-03-30T18:56:59.675+0800 connected to: mongodb://172.16.254.130:27017/ 2021-03-30T18:57:00.681+0800 [#.......................] db6.db6 48000/900000 (5.3%) 2021-03-30T18:57:01.677+0800 [###.....................] db6.db6 144000/900000 (16.0%) 2021-03-30T18:57:02.676+0800 [#####...................] db6.db6 216000/900000 (24.0%) 2021-03-30T18:57:03.677+0800 [########................] db6.db6 304000/900000 (33.8%) 2021-03-30T18:57:04.681+0800 [##########..............] db6.db6 376000/900000 (41.8%) 2021-03-30T18:57:05.676+0800 [############............] db6.db6 464000/900000 (51.6%) 2021-03-30T18:57:06.678+0800 [##############..........] db6.db6 528000/900000 (58.7%) 2021-03-30T18:57:07.678+0800 [################........] db6.db6 608000/900000 (67.6%) 2021-03-30T18:57:08.677+0800 [##################......] db6.db6 680000/900000 (75.6%) 2021-03-30T18:57:09.680+0800 [####################....] db6.db6 768000/900000 (85.3%) 2021-03-30T18:57:10.677+0800 [######################..] db6.db6 848000/900000 (94.2%) 2021-03-30T18:57:11.219+0800 [########################] db6.db6 900000/900000 (100.0%) 2021-03-30T18:57:11.219+0800 exported 900000 records
2、mongoimport导入csv文件
mongoimport --host 172.16.254.130 --port 27017 -u admin --authenticationDatabase admin -d db6 -c maclean --type csv -f 'name,name1,name2,name3' --file /mongodb/backup/db6.csv Enter password: 2021-03-31T11:39:08.533+0800 connected to: mongodb://172.16.254.130:27017/ 2021-03-31T11:39:11.533+0800 [####....................] db6.maclean 5.19MB/27.5MB (18.9%) 2021-03-31T11:39:14.536+0800 [#########...............] db6.maclean 10.5MB/27.5MB (38.3%) 2021-03-31T11:39:17.535+0800 [#############...........] db6.maclean 15.9MB/27.5MB (58.0%) 2021-03-31T11:39:20.536+0800 [##################......] db6.maclean 21.3MB/27.5MB (77.4%) 2021-03-31T11:39:23.548+0800 [#######################.] db6.maclean 26.6MB/27.5MB (96.9%) 2021-03-31T11:39:24.025+0800 [########################] db6.maclean 27.5MB/27.5MB (100.0%) 2021-03-31T11:39:24.025+0800 900001 document(s) imported successfully. 0 document(s) failed to import.
3、 mongoexport导出json文件(默认)
mongoexport --host 172.16.254.130 --port 27017 -u admin --authenticationDatabase admin -d db6 -c db6 --type json -f 'name,name1,name2,name3' -o /mongodb/backup/db6.json Enter password: 2021-03-31T14:02:00.751+0800 connected to: mongodb://172.16.254.130:27017/ 2021-03-31T14:02:01.753+0800 [........................] db6.db6 32000/900000 (3.6%) 2021-03-31T14:02:02.752+0800 [##......................] db6.db6 96000/900000 (10.7%) 2021-03-31T14:02:03.755+0800 [####....................] db6.db6 152000/900000 (16.9%) 2021-03-31T14:02:04.755+0800 [#####...................] db6.db6 200000/900000 (22.2%) 2021-03-31T14:02:05.752+0800 [######..................] db6.db6 256000/900000 (28.4%) 2021-03-31T14:02:06.752+0800 [########................] db6.db6 312000/900000 (34.7%) 2021-03-31T14:02:07.753+0800 [#########...............] db6.db6 352000/900000 (39.1%) 2021-03-31T14:02:08.752+0800 [###########.............] db6.db6 416000/900000 (46.2%) 2021-03-31T14:02:09.753+0800 [############............] db6.db6 472000/900000 (52.4%) 2021-03-31T14:02:10.753+0800 [##############..........] db6.db6 528000/900000 (58.7%) 2021-03-31T14:02:11.752+0800 [###############.........] db6.db6 584000/900000 (64.9%) 2021-03-31T14:02:12.753+0800 [#################.......] db6.db6 640000/900000 (71.1%) 2021-03-31T14:02:13.753+0800 [##################......] db6.db6 696000/900000 (77.3%) 2021-03-31T14:02:14.753+0800 [###################.....] db6.db6 744000/900000 (82.7%) 2021-03-31T14:02:15.753+0800 [#####################...] db6.db6 800000/900000 (88.9%) 2021-03-31T14:02:16.753+0800 [######################..] db6.db6 856000/900000 (95.1%) 2021-03-31T14:02:17.420+0800 [########################] db6.db6 900000/900000 (100.0%) 2021-03-31T14:02:17.420+0800 exported 900000 records
4、 mongoimport导入json文件(默认)
mongoimport --host 172.16.254.130 --port 27017 -u admin --authenticationDatabase admin -d db6 -c maclean1 --type json --file /mongodb/backup/db6.json Enter password: 2021-03-31T14:04:26.417+0800 connected to: mongodb://172.16.254.130:27017/ 2021-03-31T14:04:29.419+0800 [##......................] db6.maclean1 10.8MB/98.7MB (10.9%) 2021-03-31T14:04:32.429+0800 [#####...................] db6.maclean1 21.5MB/98.7MB (21.8%) 2021-03-31T14:04:35.427+0800 [#######.................] db6.maclean1 32.3MB/98.7MB (32.7%) 2021-03-31T14:04:38.420+0800 [##########..............] db6.maclean1 43.1MB/98.7MB (43.7%) 2021-03-31T14:04:41.432+0800 [#############...........] db6.maclean1 54.2MB/98.7MB (54.9%) 2021-03-31T14:04:44.418+0800 [###############.........] db6.maclean1 64.7MB/98.7MB (65.6%) 2021-03-31T14:04:47.427+0800 [##################......] db6.maclean1 75.6MB/98.7MB (76.6%) 2021-03-31T14:04:50.420+0800 [#####################...] db6.maclean1 86.4MB/98.7MB (87.5%) 2021-03-31T14:04:53.419+0800 [#######################.] db6.maclean1 97.3MB/98.7MB (98.5%) 2021-03-31T14:04:53.829+0800 [########################] db6.maclean1 98.7MB/98.7MB (100.0%) 2021-03-31T14:04:53.829+0800 900000 document(s) imported successfully. 0 document(s) failed to import.
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/30135314/viewspace-2765902/ ,如需转载,请注明出处,否则将追究法律责任。