Linux中mongodb安裝和導出為json

采用官方工具導出mongo數據為json格式

文檔：https://docs.mongodb.com/manual/reference/program/mongoexport/

可以遠程導出，只要有host:port即可。

首先需要安裝tools:

在redhat中：

文檔：https://docs.mongodb.com/manual/tutorial/install-mongodb-on-red-hat/

1、編寫repo文件

Create a?/etc/yum.repos.d/mongodb-org-3.2.repo?file so that you can install MongoDB directly, using?yum.

[mongodb-org-3.2]
name=MongoDB Repository
baseurl=https://repo.mongodb.org/yum/redhat/$releasever/mongodb-org/3.2/x86_64/
gpgcheck=1
enabled=1
gpgkey=https://www.mongodb.org/static/pgp/server-3.2.asc

　　

2.選擇安裝功能

一共有以下幾種選擇

mongodb-org	A?metapackage?that will automatically install the four component packages listed below.
mongodb-org-server	Contains the?mongod?daemon and associated configuration and init scripts.
mongodb-org-mongos	Contains the?mongos?daemon.
mongodb-org-shell	Contains the?mongo?shell.
mongodb-org-tools	Contains the following MongoDB tools:?mongoimport?bsondump,?mongodump,mongoexport,?mongofiles,?mongooplog,?mongoperf,?mongorestore,?mongostat, and?mongotop.

如果全部安裝：

sudo yum install -y mongodb-org

如果只安裝tools

sudo yum install -y mongodb-org-tools

?

3.導出json

sudo mongoexport -h $mongoDBUri --db $db_name  -c $collection_name  -q '{$or:[{"alerts.FamilyFriendly.completed":false},{"alerts.GasAndSafety.completed":false},{"alerts.Breakfast.completed":false},{"alerts.SpokenLanguage.completed":false},{"alerts.LocationHighlights.completed":false},{"alerts.AccessibilityEnsure.completed":false},{"alerts.AirportShuttle.completed":false},{"alerts.RoomSize.completed":false},{"alerts.Renovations.completed":false}]
}' -f hotelId,alerts   -o $OUTPUTDIR/contentScore-$(date +%F)-e.json --jsonArray

• -h ?host:port
• --db db
• -c collections
• -q query string,查詢語法
• -f ?選擇導出字段
• -o ?導出文件
• --jsonArray 導出為數組，默認為{}{}{}...

?

?