Linux中kingbase数据库定时自动备份(crontab命令)
新建shell脚本vim /opt/KingbaseAutoback.sh给权限chmod 777 KingbaseAutoback.sh//777为最高权限,视自己情况修改权限数据库定时备份脚本如下:#!/bin/bash########################################################################################
·
1.新建shell脚本
vim /opt/KingbaseAutoback.sh
2.数据库定时备份脚本如下:
#!/bin/bash
####################################################################################################################
###
###Descipt: this script is used for kingbase database backup,before you run it,you should set the variables such as
### kdb_home,kdbback_dest,kdb_user,kdb_pass,kdb_host,kdb_port,kdb_list,keep_time and so on.
###
####################################################################################################################
####################### variable define ##########################
# 数据库安装目录
kdb_home="/opt/Kingbase/ES/V8/Server"
# 数据库备份的目标路径
kdbback_dest="/opt/kingbaseback"
# 数据库用户名
kdb_user="thams"
# 数据库用户密码
kdb_pass="123"
# 数据库端口号
kdb_port="54321"
# 数据库访问ip
kdb_host="192.168.216.131"
# 数据库的模式,多个模式可用逗号分隔,如"TEST,SAMPLE"
kdb_list="thams"
# 保留时间
keep_time="7"
date=$(date '+%Y%m%d%H')
kdbback_final="${kdbback_dest}/kdbback_final"
LD_LIBRARY_PATH="${kdb_home}/unixodbc/lib:${kdb_home}/lib:${kdb_home}/bin"
####################### kingbase backup dest test ##################
[ -d ${kdbback_dest} ] || mkdir -p ${kdbback_dest}
[ -d ${kdbback_final} ] || mkdir -p ${kdbback_final}
####################### kingbase backup start #######################
cd ${kdbback_dest}
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH
for db in `echo $kdb_list | sed 's/,/ /g'`; do
[ -d ${db} ] || mkdir -p ${db}
cd ${db}
##### kingbase server check as follows
${kdb_home}/bin/ksql -h ${kdb_host} -p ${kdb_port} -U ${kdb_user} -W ${kdb_pass} -c "select now();" TEMPLATE2 > /dev/null 2>&1
if [ $? -ne 0 ] ;then
echo "${date} sorry, please run the script in a kingbase server" >> backup_${db}_${date}.log
mv backup_${db}_${date}.log ${kdbback_final}
exit 1
else
echo "${date} kingbase server is ok,kingbase backup ${db} is beginning ..." >> backup_${db}_${date}.log
fi
##### end
##### kingbase backup files process as follows
${kdb_home}/bin/sys_dump -p ${kdb_port} -U ${kdb_user} -W ${kdb_pass} -h ${kdb_host} -f ${db}_${date}.dmp ${db} >> backup_${db}_${date}.log 2>&1
if [ $? -eq 0 ] ;then
tar zcvf ${db}_${date}.tar.gz ${db}_${date}.dmp*
if [ $? -eq 0 ] ;then
rm -f ${db}_${date}.dmp*
else
mv ${db}_${date}.dmp* ${kdbback_final}
fi
find . -mtime +${keep_time} -name ${db}'_*' | xargs -I {} rm {}
else
rm -f ${db}_${date}.dmp*
fi
###### end
###### kingbase backup log files process as follows
tar zcvf backup_log_${db}_${date}.tar.gz backup_${db}_${date}.log
if [ $? -eq 0 ] ;then
rm -f backup_${db}_${date}.log
else
mv backup_${db}_${date}.log ${kdbback_final}
fi
find . -mtime +${keep_time} -name backup_log_${db}'_*' | xargs -I {} rm {}
###### end
cd ${kdbback_dest}
done
exit 0
3.给权限
chmod 777 KingbaseAutoback.sh //777为最高权限,视自己情况修改权限
4.启动crontab计时器服务
service crond start
5.编辑crontab
[root@localhost opt]# crontab -e
6.写入命令,让数据库在每周的周二,周四,周六的23:30自动备份数据库
30 23 * * 2,4,6 /opt/KingbaseAutoback.sh
分 时 日 月 周 command
wq 保存命令,操作方式与vim编辑器相同
7.crontab -l 查看任务列表
[root@localhost opt]# crontab -l
30 23 * * 2,4,6 /opt/KingbaseAutoback.sh
8.可以通过cd /var/spool/mail/用户文件 查看执行情况
crontab计时器的详细用法见crontab命令 – 定时执行任务
kingbase还原数据库语句
ksql -h ip -U 用户名 -W 密码 -d 库名 -f 备份路径/xxx.sql
更多推荐
所有评论(0)