三、数据库自动备份脚本
　　1、自动备份脚本
#vim db_backup.sh
#!/bin/bash
#Auto backup for mariadb
#Date: first write on 2014.7.22
#Vertion: v1.1
date=`date +%Y-%m-%d`
datadir="tar -jcf /opt/backup/datadir-$date.tar.bz2 /data"
#alldb="mysqldump --all-databases > /opt/backup/alldb-$date.sql"
#zentaodb="mysqldump --databases zentao > /opt/backup/zentao-$date.sql"
user1=13910892224@139.com
user2=15048088251@139.com
if [ ! -d "/opt/backup/" ]; then
mkdir -p /opt/backup/
fi
mysqldump --all-databases > /opt/backup/alldb-$date.sql && mysqldump --databases zentao > /opt/backup/zentao-$date.sql
judge=`echo $?`
if [ $judge == 0 ];then
cd /opt/backup/ && tar -jcf ALLDB-$date.tar.bz2 alldb-$date.sql zentao-$date.sql --remove-files
$datadir;
judge1=`echo $?`
if [ $judge1 == 0 ];then
echo "Backup is ok!" | mail -s "Auto backup for db" $user1 $user2;
else
echo "Db is ok but datadir is failure!" | mail -s "Auto backup for db" $user1 $user2;
fi
else
echo "Backup is failure，because of db backup is faild!" | mail -s "Auto backup for db" $user1 $user2;
fi
find /opt/backup/ -type f -mtime +30 -name "*.bz2" -exec rm -rf {} ;
　　2、赋予脚本执行权限
　　chmod +x db_backup.sh
　　3、任务计划自动执行
　　#crontab -e
　　0 0 * * * /bin/sh /opt/scripts/db_backup.sh > /dev/null 2>&1
　　四、更新脚本版本：
　　数据库备份脚本v1.2
#!/bin/bash
#Auto backup for mariadb
#Date: first write on 2014.7.22
#Vertion: v1.2
date=`date +%Y-%m-%d`
user1=13910892224@139.com
user2=15048088251@139.com
main(){
tar -jcf /opt/backup/datadir-$date.tar.bz2 /data;
if [ $? -eq 0 ];then
/usr/local/mysql/bin/mysqldump --all-databases > /opt/backup/alldb-$date.sql;
if [ $? -eq 0 ];then
sleep 2
/usr/local/mysql/bin/mysqldump --databases zentao > /opt/backup/zentao-$date.sql;
if [ $? -eq 0 ];then
cd /opt/backup/
tar -jcf ALLDB-$date.tar.bz2 alldb-$date.sql zentao-$date.sql --remove-files
&& echo "Backup is ok!" | mail -s "Auto backup for db" $user2;
else
echo "Zentao db backup failure" | mail -s "Auto backup for db" $user2;
fi
else
echo "All databases backup failure" | mail -s "Auto backup for db" $user2;
fi
else
echo "Datadir backup failure，it's first step" | mail -s "Auto backup for db" $user2;
fi
find /opt/backup/ -type f -mtime +30 -name "*.bz2" -exec rm -rf {} ;
}
if [ ! -d "/opt/backup/" ]; then
mkdir -p /opt/backup/;
main;
else
main;
fi