MongoDB数据导出成CSV

# 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`;