mongoDB 數據庫導出與導入

jopen 8年前發布 | 8K 次閱讀 MongoDB NoSQL數據庫

導出數據

mongodump -h IP --port 端口 -u 用戶名 -p 密碼 -d 數據庫 -o 文件存在路徑

如果沒有用戶和密碼,可以去掉-u和-p。
如果導出本機的數據庫,可以去掉-h。
如果是默認端口,可以去掉--port。
如果想導出所有數據庫,可以去掉-d

$>mongodump -h 192.168.164.202 --port 27017 -u dbs -p Abc12345 -d paperfareTable -o  /

導出時的提示

connected to: 192.168.164.222:27017

2016-01-13T15:56:32.638+0800 DATABASE: paperfare to /paperfare

2016-01-13T15:56:32.660+0800 paperfare.system.indexes to /paperfare/system.indexes.bson

2016-01-13T15:56:32.662+0800 8 documents

2016-01-13T15:56:32.662+0800 paperfare.paperfareAutoIncTable to /paperfare/paperfareAutoIncTable.bson

2016-01-13T15:56:32.663+0800 25 documents

2016-01-13T15:56:32.663+0800 Metadata for paperfare.paperfareAutoIncTable to /paperfare/paperfareAutoIncTable.metadata.json

2016-01-13T15:56:32.663+0800 paperfare.paperfareTable to /paperfare/paperfareTable.bson

2016-01-13T15:56:32.672+0800 118 documents

2016-01-13T15:56:32.672+0800 Metadata for paperfare.paperfareTable to /paperfare/paperfareTable.metadata.json

2016-01-13T15:56:32.672+0800 paperfare.paperfareVersionTable to /paperfare/paperfareVersionTable.bson

2016-01-13T15:56:32.685+0800 1 documents

2016-01-13T15:56:32.685+0800 Metadata for paperfare.paperfareVersionTable to /paperfare/paperfareVersionTable.metadata.json

從遠程192.168.164.202 機子中導到系統根目錄下,跟目錄下會自動生成paperfare文件價,數據的備份是bson,json結尾的數據格式,

導入:

mongoimport -h IP --port 端口 -u 用戶名 -p 密碼 -d 數據庫 -c 表名 --upsert  --drop 文件名 

$>mongorestore -h 127.0.0.1 --port 27017  -p Abc12345 -d paperfare  /paperfare

一下是打出的提示:

connected to: 127.0.0.1:27017

2016-01-13T16:04:53.131+0800 /paperfare/paperfareAutoIncTable.bson

2016-01-13T16:04:53.131+0800 going into namespace [paperfare.paperfareAutoIncTable]

25 objects found

2016-01-13T16:04:53.132+0800 Creating index: { key: { _id: 1 }, name: "_id_", ns: "paperfare.paperfareAutoIncTable" }

2016-01-13T16:04:53.334+0800 /paperfare/paperfareTable.bson

2016-01-13T16:04:53.334+0800 going into namespace [paperfare.paperfareTable]

118 objects found

2016-01-13T16:04:53.336+0800 Creating index: { key: { _id: 1 }, name: "_id_", ns: "paperfare.paperfareTable" }

2016-01-13T16:04:53.341+0800 Creating index: { key: { paperfareDeparturePointList: 1 }, name: "paperfareDeparturePointList_", ns: "paperfare.paperfareTable" }

2016-01-13T16:04:53.343+0800 Creating index: { key: { paperfareDestinationPointList: 1 }, name: "paperfareDestinationPointList_", ns: "paperfare.paperfareTable" }

2016-01-13T16:04:53.345+0800 Creating index: { key: { paperfareDepartureDate: 1 }, name: "paperfareDepartureDate_", ns: "paperfare.paperfareTable" }

2016-01-13T16:04:53.347+0800 Creating index: { key: { id: 1 }, name: "id_", ns: "paperfare.paperfareTable" }

2016-01-13T16:04:53.348+0800 Creating index: { key: { seqNo: 1 }, name: "seqNo_", ns: "paperfare.paperfareTable" }

2016-01-13T16:04:53.350+0800 /paperfare/paperfareVersionTable.bson

2016-01-13T16:04:53.350+0800 going into namespace [paperfare.paperfareVersionTable]

1 objects found

2016-01-13T16:04:53.350+0800 Creating index: { key: { _id: 1 }, name: "_id_", ns: "paperfare.paperfareVersionTable" }

我是把數據導入到本地的數據庫中,結束后數據庫中可以直接找的該db。


來自: http://my.oschina.net/u/563488/blog/601938

 本文由用戶 jopen 自行上傳分享,僅供網友學習交流。所有權歸原作者,若您的權利被侵害,請聯系管理員。
 轉載本站原創文章,請注明出處,并保留原始鏈接、圖片水印。
 本站是一個以用戶分享為主的開源技術平臺,歡迎各類分享!