MongoDB数据导出成CSV

kjfhgds

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