{"id":1644,"date":"2017-09-04T10:51:10","date_gmt":"2017-09-04T02:51:10","guid":{"rendered":"http:\/\/nick.txtcc.com\/?p=1644"},"modified":"2017-09-04T10:51:14","modified_gmt":"2017-09-04T02:51:14","slug":"mongodb-%e6%95%b0%e6%8d%ae%e5%af%bc%e5%87%bamongoexport%e5%8f%af%e5%af%bc%e5%87%ba%e4%b8%batxt%e6%88%96csv","status":"publish","type":"post","link":"http:\/\/nick.txtcc.com\/index.php\/linux\/1644","title":{"rendered":"MongoDB \u6570\u636e\u5bfc\u51famongoexport(\u53ef\u5bfc\u51fa\u4e3atxt\u6216csv)"},"content":{"rendered":"

1\u3001\u6982\u8ff0<\/h2>\n
mongoexport\u547d\u4ee4\u884c\u7528\u4e8e\u6570\u636e\u7684\u5bfc\u51fa\uff0c\u9ed8\u8ba4\u5bfc\u51fa\u7684\u6587\u4ef6\u683c\u5f0f\u4e3aJSON\u683c\u5f0f\u3002\u5f53\u7136\u4e5f\u53ef\u4ee5\u6307\u5b9a\u7279\u5b9a\u7684\u6587\u4ef6\u683c\u5f0f\u3002<\/p>\n

<\/a>\n <\/a>2\u3001\u8bed\u6cd5<\/h2>\n
\n
\n
[html]\u00a0 view plain<\/a>\u00a0 copy<\/a>\n
<\/div>\n print<\/a>\n ?<\/a>\n $\"\u5728CODE\u4e0a\u67e5\u770b\u4ee3\u7801\u7247\"$ <\/a>\n $\"\u6d3e\u751f\u5230\u6211\u7684\u4ee3\u7801\u7247\"$ <\/a><\/div>\n<\/div>\n
\n
C:\\mongo\\bin><\/strong>mongoexport\u00a0-help<\/li>\n
options:<\/li>\n
\u00a0\u00a0–help\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0produce\u00a0help\u00a0message<\/li>\n
\u00a0\u00a0-v\u00a0[\u00a0–verbose\u00a0]\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0be\u00a0more\u00a0verbose\u00a0(include\u00a0multiple\u00a0times\u00a0for\u00a0more<\/li>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0verbosity\u00a0e.g.\u00a0-vvvvv)<\/li>\n
\u00a0\u00a0-h\u00a0[\u00a0–host\u00a0]\u00a0arg\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0mongo\u00a0host\u00a0to\u00a0connect\u00a0to\u00a0(\u00a0<<\/strong>\nset<\/strong>\u00a0name><\/strong>\/s1,s2\u00a0for\u00a0sets)<\/li>\n
\u00a0\u00a0–port\u00a0arg\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0server\u00a0port.\u00a0Can\u00a0also\u00a0use\u00a0–host\u00a0hostname:port<\/li>\n
\u00a0\u00a0–ipv6\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0enable\u00a0IPv6\u00a0support\u00a0(disabled\u00a0by\u00a0default)<\/li>\n
\u00a0\u00a0-u\u00a0[\u00a0–username\u00a0]\u00a0arg\u00a0\u00a0\u00a0username<\/li>\n
\u00a0\u00a0-p\u00a0[\u00a0–password\u00a0]\u00a0arg\u00a0\u00a0\u00a0password<\/li>\n
\u00a0\u00a0–dbpath\u00a0arg\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0directly\u00a0access\u00a0mongod\u00a0database\u00a0files\u00a0in\u00a0the\u00a0given<\/li>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0path,\u00a0instead\u00a0of\u00a0connecting\u00a0to\u00a0a\u00a0mongod\u00a0\u00a0server\u00a0–<\/li>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0needs\u00a0to\u00a0lock\u00a0the\u00a0data\u00a0directory,\u00a0so\u00a0cannot\u00a0be\u00a0used<\/li>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0if\u00a0a\u00a0mongod\u00a0is\u00a0currently\u00a0accessing\u00a0the\u00a0same\u00a0path<\/li>\n
\u00a0\u00a0–directoryperdb\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0if\u00a0dbpath\u00a0specified,\u00a0each\u00a0db\u00a0is\u00a0in\u00a0a\u00a0separate<\/li>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0directory<\/li>\n
\u00a0\u00a0-d\u00a0[\u00a0–db\u00a0]\u00a0arg\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0database\u00a0to\u00a0use<\/li>\n
\u00a0\u00a0-c\u00a0[\u00a0–collection\u00a0]\u00a0arg\u00a0collection\u00a0to\u00a0use\u00a0(some\u00a0commands)<\/li>\n
\u00a0\u00a0-f\u00a0[\u00a0–fields\u00a0]\u00a0arg\u00a0\u00a0\u00a0\u00a0\u00a0comma\u00a0separated\u00a0list\u00a0of\u00a0field\u00a0names\u00a0e.g.\u00a0-f\u00a0name,age<\/li>\n
\u00a0\u00a0–fieldFile\u00a0arg\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0file\u00a0with\u00a0fields\u00a0names\u00a0–\u00a01\u00a0per\u00a0line<\/li>\n
\u00a0\u00a0-q\u00a0[\u00a0–query\u00a0]\u00a0arg\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0query\u00a0filter,\u00a0as\u00a0a\u00a0JSON\u00a0string<\/li>\n
\u00a0\u00a0–csv\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0export\u00a0to\u00a0csv\u00a0instead\u00a0of\u00a0json<\/li>\n
\u00a0\u00a0-o\u00a0[\u00a0–out\u00a0]\u00a0arg\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0output\u00a0file;\u00a0if\u00a0not\u00a0specified,\u00a0stdout\u00a0is\u00a0used<\/li>\n
\u00a0\u00a0–jsonArray\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0output\u00a0to\u00a0a\u00a0json\u00a0array\u00a0rather\u00a0than\u00a0one\u00a0object\u00a0per<\/li>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Line<\/li>\n<\/ol>\n<\/div>\n
\u8bf4\u660e\uff1a<\/p>\n
-h\uff1a\u6570\u636e\u5e93\u5bbf\u4e3b\u673a\u7684IP<\/p>\n
-u\uff1a\u6570\u636e\u5e93\u7528\u6237\u540d<\/p>\n
-p\uff1a\u6570\u636e\u5e93\u5bc6\u7801<\/p>\n
-d\uff1a\u6570\u636e\u5e93\u540d\u5b57<\/p>\n
-c\uff1a\u96c6\u5408\u7684\u540d\u5b57<\/p>\n
-f\uff1a\u5bfc\u51fa\u7684\u5217\u540d<\/p>\n
-q\uff1a\u5bfc\u51fa\u6570\u636e\u7684\u8fc7\u6ee4\u6761\u4ef6<\/p>\n
–csv\uff1a\u5bfc\u51fa\u683c\u5f0f\u4e3acsv<\/p>\n
<\/a>\n <\/a>3\u3001\u793a\u4f8b<\/h2>\n
\u73b0\u6709\u5982\u4e0b\u6570\u636e\uff1a<\/p>\n $\"\"$ \n
\u73b0\u5728\u8fdb\u884c\u5168\u90e8\u5bfc\u51fa\u64cd\u4f5c\uff0c\u9ed8\u8ba4\u5bfc\u51fa\u7684\u662fJSON\u683c\u5f0f\u7684\u6570\u636e\uff1a<\/p>\n $\"\"$ \n
\u4e0a\u8ff0\u547d\u4ee4\u884c\uff1a\u4ecetest\u6570\u636e\u5e93\u4e2d\u5bfc\u51fa\u96c6\u5408\u4e3aemp\u7684\u6570\u636e\uff0c\u4fdd\u5b58\u6587\u4ef6\u5230emp.dat\u4e2d\u3002<\/p>\n
\u67e5\u770b\uff1a<\/p>\n $\"\"$ \n
\u4e0b\u9762\u662f\u5bfc\u51facsv\u683c\u5f0f\u7684\u547d\u4ee4\uff1a<\/p>\n $\"\"$ \n
\u67e5\u770b\uff1a<\/p>\n $\"\"$ \n
\u5b9e\u6218\u793a\u4f8b\uff1a<\/p>\n
1\u3001\u5c06\u96c6\u5408\u4e2daccount\u548cbalance\u5b57\u6bb5\u5bfc\u51fa\u4e3atxt\u683c\u5f0f<\/p>\n
mongoexport -h 127.0.0.1 –port 27017 –username username \u00a0–password password \u00a0–collection accounts -f account,balance –out \/usr\/local\/bak\/db\/1.txt –db dbname<\/p>\n
2\u3001\u5c06\u96c6\u5408\u4e2daccount\u548cbalance\u5b57\u6bb5\u5bfc\u51fa\u4e3acsv\u683c\u5f0f<\/p>\n
mongoexport -h 127.0.0.1 –port 27017 –username\u00a0username\u00a0–csv –password\u00a0password\u00a0 –collection accounts -f account,balance –out \/usr\/local\/bak\/db\/1.csv –db\u00a0dbname<\/p>","protected":false},"excerpt":{"rendered":"
1\u3001\u6982\u8ff0 mongoexport\u547d\u4ee4\u884c\u7528\u4e8e\u6570\u636e\u7684\u5bfc\u51fa\uff0c\u9ed8\u8ba4\u5bfc\u51fa\u7684\u6587\u4ef6\u683c\u5f0f\u4e3aJSON\u683c\u5f0f\u3002\u5f53\u7136\u4e5f\u53ef\u4ee5\u6307\u5b9a\u7279\u5b9a\u7684\u6587\u4ef6\u683c\u5f0f\u3002 2\u3001\u8bed\u6cd5 [html]\u00a0view plain\u00a0copy print ? C:\\m...<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,101],"tags":[483,395],"class_list":["post-1644","post","type-post","status-publish","format-standard","hentry","category-linux","category-db","tag-export","tag-mongo"],"_links":{"self":[{"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/posts\/1644","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/comments?post=1644"}],"version-history":[{"count":1,"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/posts\/1644\/revisions"}],"predecessor-version":[{"id":1650,"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/posts\/1644\/revisions\/1650"}],"wp:attachment":[{"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/media?parent=1644"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/categories?post=1644"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/tags?post=1644"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}