redmine数据库备份

近日项目需要，使用redmine项目管理软件，要对数据库进行定期备份，这里采用 crontab + shell + hdfs方法：

首先编写脚本文件 redmine_backups.sh

#!/bin/bash

backfile=/home/cloud/zhuqingping/redmine_mysql_bak/redmine-`date +%Y%m%d-%H%M%S`.sql
logfile=/home/cloud/zhuqingping/redmine_mysql_bak/backups-`date +%Y%m%d-%H%M%S`.log

/home/cloud/redmine-2.6.1-0/mysql/bin/mysqldump -h localhost -u bitnami -pba848c7fc2 bitnami_redmine > $backfile  2> $logfile
/home/work/software/hadoop/bin/hadoop fs -put $backfile /home/cloud/zhuqingping/redmine_mysql_bak/
/home/work/software/hadoop/bin/hadoop fs -put $logfile /home/cloud/zhuqingping/redmine_mysql_bak/

crontab定时执行redmine_backups.sh脚本 //crontab -l

17 13 * * * /bin/bash /home/cloud/zhuqingping/redmine_mysql_bak/redmine_backups.sh