首页 > 数据库技术 > 详细

MongoDB数据导出成CSV

时间:2016-07-19 02:30:15      阅读:348      评论:0      收藏:0      [点我收藏+]


# articles

mongoexport -d mean-npbao -c articles --type=csv -f _id,type,title,author,brief,html,content,urls,client,created -o /root/hmg/articles.csv

mongoexport -d mean-npbao -c articles --type=csv -f _id,type -o /root/hmg/articles/type.csv

mongoexport -d mean-npbao -c articles --type=csv -f _id,title -o /root/hmg/articles/title.csv

mongoexport -d mean-npbao -c articles --type=csv -f _id,author -o /root/hmg/articles/author.csv

mongoexport -d mean-npbao -c articles --type=csv -f _id,brief -o /root/hmg/articles/brief.csv

mongoexport -d mean-npbao -c articles --type=csv -f _id,html -o /root/hmg/articles/html.csv

mongoexport -d mean-npbao -c articles --type=csv -f _id,content -o /root/hmg/articles/content.csv

mongoexport -d mean-npbao -c articles --type=csv -f _id,urls -o /root/hmg/articles/urls.csv

mongoexport -d mean-npbao -c articles --type=csv -f _id,client -o /root/hmg/articles/client.csv

mongoexport -d mean-npbao -c articles --type=csv -f _id,created -o /root/hmg/articles/created.csv


# clients

mongoexport -d mean-npbao -c clients --type=csv -f _id,uuid,name,icon,city,sex,created -o /root/hmg/clients.csv

mongoexport -d mean-npbao -c clients --type=csv -f _id,uuid -o /root/hmg/clients/uuid.csv

mongoexport -d mean-npbao -c clients --type=csv -f _id,name -o /root/hmg/clients/name.csv

mongoexport -d mean-npbao -c clients --type=csv -f _id,icon -o /root/hmg/clients/icon.csv

mongoexport -d mean-npbao -c clients --type=csv -f _id,city -o /root/hmg/clients/city.csv

mongoexport -d mean-npbao -c clients --type=csv -f _id,sex -o /root/hmg/clients/sex.csv

mongoexport -d mean-npbao -c clients --type=csv -f _id,created -o /root/hmg/clients/created.csv


# discusses

mongoexport -d mean-npbao -c discusses --type=csv -f _id,str,article,client,toClient,created -o /root/hmg/discusses.csv


scp /root/hmg.zip  root@131.201.81.27:/root

zip -r hmg.zip hmg/


select *

into outfile ‘/usr/local/mysql/rea_tpc1.TXT‘

fields terminated by ‘,‘ optionally enclosed by ‘‘‘‘

lines terminated by ‘\n‘

from `rea_tpc`;


本文出自 “熔 岩” 博客,谢绝转载!

MongoDB数据导出成CSV

原文:http://lavasoft.blog.51cto.com/62575/1827375

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!