linux下mysql备份脚本：
#!/bin/bash
#mysql autobackup shell#write by tuspark.cn
#-------------------数据库相关的用户名、密码、需要备份的数据库名、备份目录等
dbuser=root
dbpasswd=xxxxx
dbserver=localhost
dbname=xxxxx
dbopt=--opt
backupdir=/dcbackup/
#-------------------是否开启ftp远程备份，0为否，1为是。
copytoftp=1
ftpserver=xxxxx
ftpuser=xxxxx
ftppasswd=xxxxx
#-------------------以下参数
fileprefix=dcradiusdump
filename=$backupdir`date +%f`.sql
newfile=$fileprefix-`date +%f`.tar.gz
keepdays=10
#-------------------以下为备份时的日志
logfile=/var/log/mysqlbackup.log
logtmp=/var/log/mybackup.tmp
#===============================================
if [ ! -d $backupdir ]
then
echo $backupdir is not exist, then make ... >> $logfile
mkdir -p $backupdir
fi
echo start====================================>>>$logfile
echo beginning backup `date '+%f %t'` >>$logfile
echo delete $keepdays days ago files ... >>$logfile
find $backupdir -name $fileprefix* -mtime +$keepdays -fls $logtmp -exec rm {} \;
echo deleted backup file is :>>$logfile
cat $logtmp >>$logfile
echo delete old file success! >>$logfile
if [ -f $backupdir$newfile ]
then
echo $newfile backup exist, backup stop ... >>$logfile
else
if [ -z $dbpasswd ]
then
mysqldump -u$dbuser -h$dbserver $dbopt $dbname >$dumpfilename
else
mysqldump -u$dbuser -p$dbpasswd -h$dbserver $dbopt $dbname >$dumpfilename
fi
tar czvf $backupdir$newfile $dumpfilename >>$logfile 2>&1
echo $backupdir$newfile backup success! >>$logfile
rm -fr $dumpfilename
if [ $copytoftp = 1 ]; then
if [ -z $ftpserver ];then
echo ftp server not set,copy to ftp failed ... >>$logfile
exit 1
elif [ -z $ftpuser ];then
echo ftp user not set, copy to ftp failed ... >>$logfile
exit 2
elif [ -z $ftppasswd ]; then
echo ftp password not set, copy to ftp failed ... >>$logfile
exit 3
else
echo start copy to ftp server .... >> $logfile
ftp -n>$logfile
fi
，