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.