MongoDB data export to 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 [Email Protected]:/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 ';

This article is from "Lava" blog, declined reprint!

MongoDB data export to CSV