mongodb导入csv文件

使用命令 mongoimport

参数 h  主机ip+端口

          d  要导入的db

          c  要导入的collections

          f  指定字段

          type=类型

         file 导入的文件路径

演示如下：

root@localhost bin]# ./mongoimport -h 192.168.1.151:27017 -d "logs" -c "logs" -f "Server,IP,Username,Account,DateTime,Program,Type,Operation,Message,MessageId" -type=csv -file=/root/test-date.csv
connected to: 192.168.1.151:27017
                6854400/5440597038      0%
                        9600    3200/second
                23847600/5440597038     0%
                        33400   5566/second
                36699600/5440597038     0%
                        51400   5711/second
                52264800/5440597038     0%
                        73200   6100/second
                66330600/5440597038     1%
                        92900   6193/second
                81039000/5440597038     1%
                        113500  6305/second
                97032600/5440597038     1%
                        135900  6471/second
                111812400/5440597038    2%
                        156600  6525/second
                120666000/5440597038    2%
                        169000  6259/second
                136302600/5440597038    2%
                        190900  6363/second