🔥码云GVP开源项目 12k star Uniapp+ElementUI 功能强大 支持多语言、二开方便! 广告
### Mongodb的导出mongodump和mongorestore导入工具结合使用。可以用于数据库的备份和还原。 mongodump是用于创建数据库内容的二进制导出的实用程序。 mongodump可以从mongod或mongos实例中导出数据;即可以从独立,副本集和分片群集部署中导出数据。 为了避免影响线上的业务,我们才使用mongodup工具时,尽可能在副本集的从节点或者延迟节点执行操作。 >mongodump和mongorestore不能成为正在进行分片事务的4.2分片群集的备份策略的一部分,因为用mongodump创建的备份不能保持跨分片事务的原子性保证。 ``` 官网也强调: 对于具有正在进行的分片事务的4.2分片群集,请使用以下协调的备份和还原过程之一,该过程确实维护了跨分片事务的原子性保证: MongoDB Atlas, MongoDB Cloud Manager, or MongoDB Ops Manager. ``` ### 1、可以使用mongodump --help 查看帮助文档使用方法。 只要我们安装了mongodb服务,就能够使用mongodump命令, #### 1.1、备份整个实例: >mongodump -h IP:Port -o 导出到目录 ``` [root@VM_6_17_centos ~]# /root/mongodb-4.2.1/bin/mongodump -h 192.168.6.17:27020 -o dump/ 2020-05-27T10:49:21.610+0800 writing admin.system.version to 2020-05-27T10:49:21.610+0800 done dumping admin.system.version (1 document) 2020-05-27T10:49:21.611+0800 writing test_haijiao.user_file to 2020-05-27T10:49:21.611+0800 writing test_jia.user_info to 2020-05-27T10:49:21.611+0800 done dumping test_jia.user_info (2 documents) 2020-05-27T10:49:21.611+0800 done dumping test_haijiao.user_file (1 document) ``` #### 1.2、备份单个数据库: >mongodump -h IP:Port -d 数据库名 -o 导出到目录 ``` [root@VM_6_17_centos conf]# /root/mongodb-4.2.1/bin/mongodump -h 192.168.6.17:27020 -d test_jia -o dump/ 2020-05-27T10:53:11.404+0800 writing test_jia.user_info to 2020-05-27T10:53:11.405+0800 done dumping test_jia.user_info (2 documents) ``` #### 1.3、备份数据库的一张表: >mongodump -h IP:Port -d 数据库名 -c 集合名 -o 导出到目录 ``` [root@VM_6_17_centos conf]# /root/mongodb-4.2.1/bin/mongodump -h 192.168.6.17:27020 -d test_jia -c user_info -o dump/ 2020-05-27T10:53:49.162+0800 writing test_jia.user_info to 2020-05-27T10:53:49.162+0800 done dumping test_jia.user_info (2 documents) ``` #### 1.4、备份数据库的一张表并且过滤: 查看表里的数据我们过滤年龄大于30岁的数据 > db.user_info.find() { "_id" : ObjectId("5ecdcd0bc6a43453c65e484f"), "name" : "jiahaijiao", "age" : 32 } { "_id" : ObjectId("5ecdcde7c6a43453c65e4850"), "name" : "jiahaijiao", "age" : 32 } { "_id" : ObjectId("5ecdd6f5bf235c4a69f3b672"), "name" : "zhang", "age" : 30 } { "_id" : ObjectId("5ecdd6febf235c4a69f3b673"), "name" : "wang", "age" : 30 } { "_id" : ObjectId("5ecdd780bf235c4a69f3b674"), "name" : "li", "age" : 28 } ``` [root@VM_6_17_centos conf]# /root/mongodb-4.2.1/bin/mongodump -h 192.168.6.17:27020 -d test_jia -c user_info -q '{"age":{"$gt": 30}}' -o dump/ 2020-05-27T11:18:19.103+0800 writing test_jia.user_info to 2020-05-27T11:18:19.103+0800 done dumping test_jia.user_info (2 documents) ``` #### 1.5、导出单个库的压缩文件: ``` [root@VM_6_17_centos conf]# /root/mongodb-4.2.1/bin/mongodump -h 192.168.6.17:27020 -d test_jia -o dump/ --gzip 2020-05-27T11:19:33.748+0800 writing test_jia.user_info to 2020-05-27T11:19:33.749+0800 done dumping test_jia.user_info (5 documents) [root@VM_6_17_centos conf]# ll dump/ 总用量 4 drwxr-xr-x 2 root root 4096 5月 27 11:19 test_jia [root@VM_6_17_centos conf]# ll dump/test_jia/ 总用量 16 -rw-r--r-- 1 root root 112 5月 27 11:18 user_info.bson -rw-r--r-- 1 root root 152 5月 27 11:19 user_info.bson.gz -rw-r--r-- 1 root root 166 5月 27 11:18 user_info.metadata.json -rw-r--r-- 1 root root 151 5月 27 11:19 user_info.metadata.json.gz ``` #### 1. 6、设置导出集合并发数,加快导出速度 > -j, --numParallelCollections= number of collections to dump in parallel (4 by default) (default: 4) //默导出文档并发4个 ``` [root@VM_6_17_centos conf]# /root/mongodb-4.2.1/bin/mongodump -h 192.168.6.17:27020 -d test_jia -o dump/ --gzip -j 6 2020-05-27T11:23:34.568+0800 writing test_jia.user_info to 2020-05-27T11:23:34.569+0800 done dumping test_jia.user_info (5 documents) [root@VM_6_17_centos conf]# ``` #### 1.7、数据认证管理员备份 数据库开启认证授权以后需要使用用户名和密码,认证数据库参数进行备份。 ``` [root@VM_6_17_centos ~]# /root/mongodb-4.2.1/bin/mongodump -h 192.168.6.17:27020 -u dba -p12387654 -d test_jia -o dump/ --authenticationDatabase=admin 2020-05-27T15:06:51.049+0800 writing test_jia.user_info to 2020-05-27T15:06:51.050+0800 done dumping test_jia.user_info (5 documents) [root@VM_6_17_centos ~]# ``` ### 2、mongorestore 将mongodump生成的备份还原到正在运行的实例 #### 2.1、还原整个实例 ``` [root@VM_6_17_centos ~]# /root/mongodb-4.2.1/bin/mongorestore -h 192.168.6.17:27030 dump/ 2020-05-27T15:25:52.968+0800 preparing collections to restore from 2020-05-27T15:25:52.970+0800 reading metadata for test_jia.user_info from dump/test_jia/user_info.metadata.json 2020-05-27T15:25:52.973+0800 reading metadata for test_haijiao.user_file from dump/test_haijiao/user_file.metadata.json 2020-05-27T15:25:52.996+0800 restoring test_jia.user_info from dump/test_jia/user_info.bson 2020-05-27T15:25:52.998+0800 no indexes to restore 2020-05-27T15:25:52.998+0800 finished restoring test_jia.user_info (5 documents, 0 failures) 2020-05-27T15:25:53.007+0800 restoring test_haijiao.user_file from dump/test_haijiao/user_file.bson 2020-05-27T15:25:53.011+0800 no indexes to restore 2020-05-27T15:25:53.011+0800 finished restoring test_haijiao.user_file (1 document, 0 failures) 2020-05-27T15:25:53.011+0800 restoring users from dump/admin/system.users.bson 2020-05-27T15:25:53.078+0800 6 document(s) restored successfully. 0 document(s) failed to restore. ``` [root@VM_6_17_centos ~]# #### 2.1、还原单个库 ``` [root@VM_6_17_centos ~]# /root/mongodb-4.2.1/bin/mongorestore -h 192.168.6.17:27030 --db test_jia dump/test_jia/ 2020-05-27T15:35:06.633+0800 the --db and --collection args should only be used when restoring from a BSON file. Other uses are deprecated and will not exist in the future; use --nsInclude instead 2020-05-27T15:35:06.634+0800 building a list of collections to restore from dump/test_jia dir 2020-05-27T15:35:06.634+0800 reading metadata for test_jia.user_info from dump/test_jia/user_info.metadata.json 2020-05-27T15:35:06.657+0800 restoring test_jia.user_info from dump/test_jia/user_info.bson 2020-05-27T15:35:06.658+0800 no indexes to restore 2020-05-27T15:35:06.658+0800 finished restoring test_jia.user_info (5 documents, 0 failures) 2020-05-27T15:35:06.658+0800 5 document(s) restored successfully. 0 document(s) failed to restore. ``` #### 2.2、还原库的单个表 ``` [root@VM_6_17_centos ~]# /root/mongodb-4.2.1/bin/mongorestore -h 192.168.6.17:27030 --db test_jia -c user_info dump/test_jia/user_hobby.bson 2020-05-27T15:47:52.552+0800 checking for collection data in dump/test_jia/user_hobby.bson 2020-05-27T15:47:52.552+0800 restoring to existing collection test_jia.user_info without dropping 2020-05-27T15:47:52.552+0800 reading metadata for test_jia.user_info from dump/test_jia/user_hobby.metadata.json 2020-05-27T15:47:52.552+0800 restoring test_jia.user_info from dump/test_jia/user_hobby.bson 2020-05-27T15:47:52.613+0800 no indexes to restore 2020-05-27T15:47:52.613+0800 finished restoring test_jia.user_info (1 document, 0 failures) 2020-05-27T15:47:52.613+0800 1 document(s) restored successfully. 0 document(s) failed to restore. ``` #### 2.3、压缩备份文件,还原 ``` [root@VM_6_17_centos ~]# /root/mongodb-4.2.1/bin/mongorestore -h 192.168.6.17:27030 --gzip --db test_jia dump/test_jia/ 2020-05-27T15:54:05.013+0800 the --db and --collection args should only be used when restoring from a BSON file. Other uses are deprecated and will not exist in the future; use --nsInclude instead 2020-05-27T15:54:05.013+0800 building a list of collections to restore from dump/test_jia dir 2020-05-27T15:54:05.014+0800 reading metadata for test_jia.user_info from dump/test_jia/user_info.metadata.json.gz 2020-05-27T15:54:05.014+0800 reading metadata for test_jia.user_hobby from dump/test_jia/user_hobby.metadata.json.gz 2020-05-27T15:54:05.038+0800 restoring test_jia.user_info from dump/test_jia/user_info.bson.gz 2020-05-27T15:54:05.041+0800 no indexes to restore 2020-05-27T15:54:05.041+0800 finished restoring test_jia.user_info (5 documents, 0 failures) 2020-05-27T15:54:05.063+0800 restoring test_jia.user_hobby from dump/test_jia/user_hobby.bson.gz 2020-05-27T15:54:05.065+0800 no indexes to restore 2020-05-27T15:54:05.065+0800 finished restoring test_jia.user_hobby (1 document, 0 failures) 2020-05-27T15:54:05.065+0800 6 document(s) restored successfully. 0 document(s) failed to restore. ``` #### 2.4、还原时删除已存在的集合 ``` [root@VM_6_17_centos ~]# /root/mongodb-4.2.1/bin/mongorestore -h 192.168.6.17:27030 --gzip --drop --db test_jia -c user_info dump/test_jia/user_info.bson.gz 2020-05-27T15:57:18.065+0800 checking for collection data in dump/test_jia/user_info.bson.gz 2020-05-27T15:57:18.070+0800 reading metadata for test_jia.user_info from dump/test_jia/user_info.metadata.json.gz 2020-05-27T15:57:18.085+0800 restoring test_jia.user_info from dump/test_jia/user_info.bson.gz 2020-05-27T15:57:18.146+0800 no indexes to restore 2020-05-27T15:57:18.146+0800 finished restoring test_jia.user_info (5 documents, 0 failures) 2020-05-27T15:57:18.146+0800 5 document(s) restored successfully. 0 document(s) failed to restore. ``` #### 2.5、还原设置并行集合数 默认并行集合数为4,我们可以设置该参数 ``` [root@VM_6_17_centos ~]# /root/mongodb-4.2.1/bin/mongorestore -h 192.168.6.17:27030 --gzip --drop dump/ -j 6 2020-05-27T16:15:17.370+0800 preparing collections to restore from 2020-05-27T16:15:17.375+0800 reading metadata for test_jia.user_info from dump/test_jia/user_info.metadata.json.gz 2020-05-27T16:15:17.379+0800 reading metadata for test_jia.user_hobby from dump/test_jia/user_hobby.metadata.json.gz 2020-05-27T16:15:17.404+0800 restoring test_jia.user_info from dump/test_jia/user_info.bson.gz 2020-05-27T16:15:17.407+0800 no indexes to restore 2020-05-27T16:15:17.407+0800 finished restoring test_jia.user_info (5 documents, 0 failures) 2020-05-27T16:15:17.412+0800 restoring test_jia.user_hobby from dump/test_jia/user_hobby.bson.gz 2020-05-27T16:15:17.413+0800 no indexes to restore 2020-05-27T16:15:17.413+0800 finished restoring test_jia.user_hobby (1 document, 0 failures) 2020-05-27T16:15:17.413+0800 6 document(s) restored successfully. 0 document(s) failed to restore. [root@VM_6_17_centos ~]# ``` #### 2.5、开启认证管理员恢复 ``` [root@VM_6_17_centos ~]# /root/mongodb-4.2.1/bin/mongorestore -h 192.168.6.17:27030 --gzip --drop --dir dump/ -j 6 -u dba -p12387654 --authenticationDatabase=admin 2020-05-27T16:22:23.883+0800 preparing collections to restore from 2020-05-27T16:22:23.899+0800 reading metadata for test_jia.user_hobby from dump/test_jia/user_hobby.metadata.json.gz 2020-05-27T16:22:23.940+0800 restoring test_jia.user_hobby from dump/test_jia/user_hobby.bson.gz 2020-05-27T16:22:23.941+0800 reading metadata for test_jia.user_info from dump/test_jia/user_info.metadata.json.gz 2020-05-27T16:22:23.942+0800 no indexes to restore 2020-05-27T16:22:23.942+0800 finished restoring test_jia.user_hobby (1 document, 0 failures) 2020-05-27T16:22:23.964+0800 restoring test_jia.user_info from dump/test_jia/user_info.bson.gz 2020-05-27T16:22:23.965+0800 no indexes to restore 2020-05-27T16:22:23.966+0800 finished restoring test_jia.user_info (5 documents, 0 failures) 2020-05-27T16:22:23.966+0800 6 document(s) restored successfully. 0 document(s) failed to restore. ``` 在数据量较小的情况下可是使用mongodump进行备份,数据大的情况下可以使用复制集的延迟备份,云服务器的磁盘快照进行备份。 关于增量oplog备份请点击以下链接。 [`Mongodb恢复到任意时间点`](https://blog.51cto.com/jiachen/2486045)