mongoDB 数据库导出与导入

jopen 3年前

导出数据

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