mysql_backup.sh

#!/bin/bashpath=/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbinexport path#数据库用户名dbuser='1111'#数据库用密码dbpasswd='2222'#备份数据库dbname='3333'#备份时间BACKUP_TIME=`date  +"%Y/%m/%d %H:%M.%S"` backup_time=`date  +"%Y%m%d"`#日志备份路径logpath='/var/log/mysql_backup' [ ! -e "$logpath" ] && mkdir $logpath cd $logpath touch mysql_backup.logcd#数据备份路径datapath='/home/backup/mysql_back' [ ! -e "$datapath" ] && mkdir $datapath #日志记录头部echo "备份时间为${BACKUP_TIME},备份数据库表 ${dbname} 开始" >> ${logpath}/mysql_backup.log#正式备份数据库SQLBakName="${backup_time}.lxhp.tar.gz"mysqldump  --user=$dbuser --password=$dbpasswd --databases $dbname  > $datapath/mysql_backup_${backup_time}.sqlfind $datapath -type f -mtime +7 -exec rm -rf {} \; > /dev/null 2>&1