mongodb数据库备份

1.导出数据

mongoexport -d my_mongodb -c choice -o choice.dat

參数说明:

-d 指明使用的库, 本例中为” my_mongodb”


-c 指明要导出的表, 本例中为”choice ”


-o 指明要导出的文件名称, 本例中为”choice .dat”


-h server地址


2.导入数据
mongoimport -d my_mongodb -c choice choice .dat


參数说明:


-d 指明使用的库, 本例中为” my_mongodb”


-c 指明要导入的表, 本例中为”choice ”


3.整库备份:
mongodump -h dbhost -d dbname -o dbdirectory


-h:MongDB所在server地址,比如:127.0.0.1,也能够指定port号:127.0.0.1:27017
-d:须要备份的数据库实例,比如:test
-o:备份的数据存放位置,比如:c:\data\dump。当然该文件夹须要提前建立,在备份完毕后,系统自己主动在dump文件夹下建立一个test文件夹,这个文件夹里面存放该数据库实例的备份数据。


查看具体帮助信息例如以下
D:\tool\mongodb\bin>mongodump --help
Export MongoDB data to BSON files.


options:
  --help                                produce help message
  -v [ --verbose ]                      be more verbose (include multiple times
                                        for more verbosity e.g. -vvvvv)
  --version                             print the program's version and exit
  -h [ --host ] arg                     mongo host to connect to ( <set
                                        name>/s1,s2 for sets)
  --port arg                            server port. Can also use --host
                                        hostname:port
  --ipv6                                enable IPv6 support (disabled by
                                        default)
  -u [ --username ] arg                 username
  -p [ --password ] arg                 password
  --authenticationDatabase arg          user source (defaults to dbname)
  --authenticationMechanism arg (=MONGODB-CR)
                                        authentication mechanism
  --dbpath arg                          directly access mongod database files
                                        in the given path, instead of
                                        connecting to a mongod  server - needs
                                        to lock the data directory, so cannot
                                        be used if a mongod is currently
                                        accessing the same path
  --directoryperdb                      each db is in a separate directly
                                        (relevant only if dbpath specified)
  --journal                             enable journaling (relevant only if
                                        dbpath specified)
  -d [ --db ] arg                       database to use
  -c [ --collection ] arg               collection to use (some commands)
  -o [ --out ] arg (=dump)              output directory or "-" for stdout
  -q [ --query ] arg                    json query
  --oplog                               Use oplog for point-in-time
                                        snapshotting
  --repair                              try to recover a crashed database
  --forceTableScan                      force a table scan (do not use
                                        $snapshot)



4.整库恢复:
mongorestore -h dbhost -d dbname –directoryperdb dbdirectory


-h:MongoDB所在server地址
-d:须要恢复的数据库实例,比如:test,这个名称也能够和备份时候的不一样,比方test2
–directoryperdb:备份数据所在位置,比如:c:\data\dump\test。这里为什么要多加一个test。而不是备份时候的dump
–drop:恢复的时候,先删除当前数据。然后恢复备份的数据。就是说,恢复后。备份后加入改动的数据都会被删除


查看具体帮助信息例如以下
D:\tool\mongodb\bin>mongorestore --help
Import BSON files into MongoDB.


usage: mongorestore [options] [directory or filename to restore from]
options:
  --help                                produce help message
  -v [ --verbose ]                      be more verbose (include multiple times
                                        for more verbosity e.g. -vvvvv)
  --version                             print the program's version and exit
  -h [ --host ] arg                     mongo host to connect to ( <set
                                        name>/s1,s2 for sets)
  --port arg                            server port. Can also use --host
                                        hostname:port
  --ipv6                                enable IPv6 support (disabled by
                                        default)
  -u [ --username ] arg                 username
  -p [ --password ] arg                 password
  --authenticationDatabase arg          user source (defaults to dbname)
  --authenticationMechanism arg (=MONGODB-CR)
                                        authentication mechanism
  --dbpath arg                          directly access mongod database files
                                        in the given path, instead of
                                        connecting to a mongod  server - needs
                                        to lock the data directory, so cannot
                                        be used if a mongod is currently
                                        accessing the same path
  --directoryperdb                      each db is in a separate directly
                                        (relevant only if dbpath specified)
  --journal                             enable journaling (relevant only if
                                        dbpath specified)
  -d [ --db ] arg                       database to use
  -c [ --collection ] arg               collection to use (some commands)
  --objcheck                            validate object before inserting
                                        (default)
  --noobjcheck                          don't validate object before inserting
  --filter arg                          filter to apply before inserting
  --drop                                drop each collection before import
  --oplogReplay                         replay oplog for point-in-time restore
  --oplogLimit arg                      include oplog entries before the
                                        provided Timestamp (seconds[:ordinal])
                                        during the oplog replay; the ordinal
                                        value is optional
  --keepIndexVersion                    don't upgrade indexes to newest version
  --noOptionsRestore                    don't restore collection options
  --noIndexRestore                      don't restore indexes
  --w arg (=0)                          minimum number of replicas per write






本文转自mfrbuaa博客园博客,原文链接:http://www.cnblogs.com/mfrbuaa/p/5369176.html,如需转载请自行联系原作者

上一篇:DL之DNN:利用MultiLayerNet模型【6*100+ReLU+SGD,weight_decay】对Mnist数据集训练来抑制过拟合


下一篇:《企业迁云实战》——3.3 应用架构设计