如何使用脚本自动备份阿里云rds数据库_Aaron-x的博客-CSDN博客

安宇雨 - 随手采集
2020-12-10 11:14:11
随手采集
0000-未整理-等待研究

转载：https://www.cnblogs.com/zoulixiang/p/9395382.html

vim .mysqldump.sh #脚本都放置到/d20141212/scripts下,创建.mysqldump.sh的文件目的是，这个文件里有数据库的连接信息，要隐藏掉。所以加了.。
```
#!/bin/bash
```

shopt -s -o nounset
export PATH=/usr/bin/:/bin

bakdir=/d20141212/dbback/msyql
date=$(date +%Y_%m_%d_%H)
dbname=‘XXX’ #数据库名称
dbuser=‘XXX’ #数据库用户
dbpwd=‘XXX’ #数据库密码

dbip=‘XX.XX.XX.XX’ #阿里云内网连接地址

if [ ! -d b a k d i r < / s p a n > < s p a n c l a s s = " t o k e n p u n c t u a t i o n " > ] < / s p a n > < s p a n c l a s s = " t o k e n k e y w o r d " > t h e n < / s p a n > < s p a n c l a s s = " t o k e n f u n c t i o n " > m k d i r < / s p a n > − p < s p a n c l a s s = " t o k e n v a r i a b l e " > bakdir ] then mkdir -p bakdir<spanclass="tokenpunctuation">]<spanclass="tokenkeyword">then<spanclass="tokenfunction">mkdir−p<spanclass="tokenvariable">bakdir
fi

mysqldump --set-gtid-purged=OFF -h d b i p < / s p a n > − u < s p a n c l a s s = " t o k e n v a r i a b l e " > dbip -u dbip−u<spanclass="tokenvariable">dbuser -p d b p w d < / s p a n > − − l o c k − t a b l e s < s p a n c l a s s = " t o k e n v a r i a b l e " > dbpwd --lock-tables dbpwd−−lock−tables<spanclass="tokenvariable">dbname | gzip> b a k d i r < / s p a n > / < s p a n c l a s s = " t o k e n v a r i a b l e " > bakdir/ bakdir/<spanclass="tokenvariable">{dbname}_$date.sql.gz