初探mongo之备份还原

由于之前一直使用的是mysql,现在换成了mongo,一开始不太适应。第一个练手项目选择了mongo备份和还原。

#!/bin/bash
#creates backup files(bson) of given MongoDB or collections on a given server
#mongo dump and tar the output into a file named dbname_date.ex: dbname_201610241655.tar.gz
#by keith_testing 


#setting of  server 
Host="127.0.0.1"
Port="27017" #default mongo port
UserName="xxx"
PassWord="xxx"


#auto detect mongodump and mongorestore bin path
Mongodump_Bin_path="$(which mongodump)"
Mongoretore_Bin_path="$(which mongorestore)"


Date=$(date -d '+0 dayes' +%Y%md%H%M)
Backup_DB_Name="xxxx"
Tar_Backup_File_Name=$Backup_DB_Name"_"$Date".tar.gz"


#set backup path
Backup_Path="/backup"
Tmp_Backup_Path="/tmpbackup"
Tmp_Backup_Dir=$Tmp_Backup_Path/$Date   #mongodump output file path


#backup collections array
#add --quiet help hidden mongo output info ,or array will contains the mongo info ,such as mongo version ,connection info 
#grep -v "^log_"  means array donot contains the collection which start with "log_".ex "log_role_level "
collections_arr=`echo "show collections; " | mongo $Backup_DB_Name --quiet | grep -v "^log_"`


#create backup path if it does not exist
if [ ! -d $Backup_Path ];then
    mkdir -p $Backup_Path
fi


if [ ! -d $Tmp_Backup_Path];then
    mkdir -p $Tmp_Backup_Path
fi


if [ -d "$Backup_Path " ];then
    cd $Backup_Path 
    for collection in ${collections_arr}
    do
        #--authenticationDatabase admin,if it doesnot work ,add it 
        $Mongodump_Bin_path --hot $Host:$Port -u $UserName -p $PassWord -d $Backup_DB_Name -c $collection --authenticationDatabase admin --out $Tmp_Backup_Dir/ >>/dev/null
    done


    if [ -d "$Tmp_Backup_Dir" ];then
        tar -zcvf $Backup_Path/$Tar_Backup_File_Name -C $Tmp_Backup_Dir . >>/dev/null
        if [ $? = 0 ];then
            rm -rf $Tmp_Backup_Dir/*
            echo "Backup sucess:`du -sh $Tar_Backup_File_Name`"
            echo "Output file path : $Backup_Path/$Tar_Backup_File_Name"
        else
            echo "Could not create tar file : $Backup_Path/$Tar_Backup_File_Name"
        fi
    else
        echo "Could not dump mongo db collections to $Tmp_Backup_Dir";echo;
else
    "Could not find path : $Backup_Path,fail to backup"
fi


#restore the collections
#it will not work ,if it has no --host param 
#--drop clear the colletion ,and then restore the collection
#Restore_Path is the direction which contains the files *.bson and *.json
#Restore_Path:you can tar -zxvf $Tar_Backup_File_Name -C Restore_Path
Restore_Path="restore"

$Mongoretore_Bin_path --host $Host -d $Backup_DB_Name --drop $Restore_Path


期间碰到了挺多问题,不过mongo --help或mongodump --help和谷歌一起解决了不少的问题

致清除了的坑


  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
如果你忘记了在Docker中运行的Mongo数据库的用户名和密码,可以按照以下步骤进行操作: 1. 首先,进入Mongo的Docker容器。使用以下命令: ``` docker exec -it mongo bash ``` 2. 进入Mongo命令行界面。使用以下命令: ``` mongo ``` 3. 在admin数据库中创建一个root用户。使用以下命令: ``` db.createUser({ user:'admin', pwd:'123456', roles:\[ { role:'userAdminAnyDatabase', db: 'admin'}\]}) ``` 4. 创建一个超级用户。使用以下命令: ``` db.createUser({ user: "root" , pwd: "root", roles: \["root"\]}) ``` 现在你可以使用这些用户名和密码来访问Mongo数据库了。如果你想删除特定的用户,可以使用以下命令: - 删除指定用户:`db.system.users.remove({user:"AUser"})` - 删除指定数据库下的用户(假设数据库名为accountdb):`use accountdb.dropUser("AUser")` 请注意,如果你修改了Mongo的配置文件或重启了Docker容器,你可能需要重新执行上述步骤来设置用户名和密码。 #### 引用[.reference_title] - *1* *3* [docker-mongo添加用户名密码](https://blog.csdn.net/brightgreat/article/details/123437638)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^insert_down28v1,239^v3^insert_chatgpt"}} ] [.reference_item] - *2* [Docker安装Mongo并设置用户名密码](https://blog.csdn.net/m0_46205920/article/details/106115173)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^insert_down28v1,239^v3^insert_chatgpt"}} ] [.reference_item] [ .reference_list ]
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值