linux mysql定时备份数据库

 新建  database_bak.sh

#!/usr/bin/bash
#备份目录
dic="/usr/local/bak"
y=$(date +%Y)
m=$(date +%m)
d=$(date +%d)
h=$(date +%H)
M=$(date +%M)
#read -p "dbname:" dbname

#if [ ! -n "$dbname" ];then
#     echo "not set dbname"
#     exit
#fi

dbname="xxxx"

#mysql备份文件名
filename=$dic/$dbname_$y$m$d$h$M.sql

#echo "bakup name:"$filename

#删除3天前的备份文件
for file in `ls -a $dic`
do
 find -mtime 3 -name "*.tar" -exec rm -rf {} \;
done

#备份数据库
#echo "备份数据库"
mysqldump  $dbname > $filename

修改/etc/my.cnf,添加以下内容

[client]
host=localhost
user=root
password=123456789

执行  ./database_bak.sh