The import/export can operate on a local MONGODB server, or it can be remote.
Therefore, the following general options are available:
-H Host
--port Port Ports
-u username user name
-P passwd Password
Mongoexport exporting files in JSON format
Q: Which library, which table, which columns, which rows are exported?
-D Library Name
-C Table Name
-F Field1,field2 ... Column Name
-Q Query criteria
-O Exported file name
--CSV Export CSV format (easy to exchange data with traditional database)
Cases:
[Email protected] mongodb]#/bin/mongoexport-d test-c news-o Test.json
Connected to:127.0.0.1
Exported 3 Records
[[email protected] mongodb]# ls
Bin dump gnu-agpl-3.0 README Test.json third-party-notices
[Email protected] mongodb]# more Test.json
{"_id": {"$oid": "51fc59c9fecc28d8316cfc03"}, "title": "AAAA"}
{"_id": {"$oid": "51fcaa3c5eed52c903a91837"}, "title": "Today is Sataday"}
{"_id": {"$oid": "51fcaa445eed52c903a91838"}, "title": "OK Now"}
Example 2: Export only goods_id,goods_name columns
./bin/mongoexport-d test-c goods-f goods_id,goods_name-o Goods.json
Example 3: Export only rows with prices below $1000
./bin/mongoexport-d test-c goods-f goods_id,goods_name,shop_price-q ' {shop_price:{$lt: +} '-O Goods.json
Note: _id columns are always exported
Mongoimport Import
-D database to import
-c table to be imported (does not exist to be created by itself)
--type Csv/json (default)
--file backup File path
Example 1: Importing JSON
./bin/mongoimport-d Test-c Goods--file./goodsall.json
Example 2: Importing CSV
./bin/mongoimport-d test-c Goods--typecsv-f goods_id,goods_name--file./goodsall.csv
./bin/mongoimport-d test-c Goods--typecsv --headline -F goods_id,goods_name--file./goodsall.csv
Mongodump Exporting binary Bson structure data and its index information
-D Library Name
-C Table Name
-F Field1,field2 ... Column Name
Cases:
mongodump-d test [-C table name]--out export Path
Law:
1: The exported file is placed in a directory named database
2: Each table exports 2 files, respectively, Bson structure data files (such as: Goods.bson), JSON index information (such as: Goods.metadata.json)
3: If you do not declare a table name, export all tables
Example: mongodump-d test--out C:\Users\yuxl\Desktop\mongodb\mongod\mongodumptest
Mongorestore Importing binary files
Cases:
./bin/mongorestore-d Test--dir Path
Example: mongorestore-d test--dir C:\Users\yuxl\Desktop\mongodb\mongodumptest\test
Binary backup that not only backs up data, but also backs up indexes,
Backup data is relatively small.
MongoDB Import and Export (7)