| 注册
请输入搜索内容

热门搜索

Java Linux MySQL PHP JavaScript Hibernate jQuery Nginx
jopen
9年前发布

mongoDB 数据库导出与导入

导出数据

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 自行上传分享,仅供网友学习交流。所有权归原作者,若您的权利被侵害,请联系管理员。
 转载本站原创文章,请注明出处,并保留原始链接、图片水印。
 本站是一个以用户分享为主的开源技术平台,欢迎各类分享!
 本文地址:https://www.open-open.com/lib/view/open1452738752792.html
MongoDB NoSQL数据库