备份MySQL数据库的Shell脚本
#!/bin/bash
#Desc: 备份MySQL数据库
#Author: Beetester
#同步系统时间
ntpdate asia.pool.ntp.org &> /dev/null
#把当前系统时间按照年月日格式赋值给变量date
date=$(date +%y%m%d_%H%M)
#统计MySQL数据库的大小并把大小赋值给size变量
size=$(du -sh /var/lib/mysql)
if [ -d /tmp/dbbak ]
then
echo “Date : $date!” > /tmp/dbbak/dbinfo.txt
echo “Data size: $size” >> /tmp/dbbak/dbinfo.txt
cd /tmp/dbbak
tar -zcf mysql-lib-$date.tar.gz /var/lib/mysql dbinfo.txt &> /dev/null
rm -rf /tmp/dbbak/dbinfo.txt
else
mkdir /tmp/dbbak
echo “Date : $date!” > /tmp/dbbak/dbinfo.txt
echo “Data size: $size” >> /tmp/dbbak/dbinfo.txt
cd /tmp/dbbak
tar -zcf mysql-lib-$date.tar.gz /var/lib/mysql dbinfo.txt &> /dev/null
rm -rf /tmp/dbbak/dbinfo.txt
fi