Linux备份mysql数据库
Linux下备份mysql数据库脚本,自动打包为tar.gz包并删除超过10天的备份文件。
#!/bin/sh # mysql data backup script # # use mysqldump --help,get more detail. # BakDir=/home/data/backup/mysqlbackup LogFile=/home/data/backup/mysqlbackup.log DATE=`date +%Y%m%d%H` DB_USER=root DB_PASSWORD=123456 DBList="test mysql" echo " " >> $LogFile echo " " >> $LogFile echo "-------------------------------------------" >> $LogFile echo $(date +"%y-%m-%d %H:%M:%S") >> $LogFile echo "--------------------------" >> $LogFile if [ ! -d $BakDir ];then mkdir -p $BakDir fi cd $BakDir GZDumpFile=$DATE.sql.tar.gz for db in ${DBList};do DumpFile=${db}${DATE}.sql /usr/bin/mysqldump -u $DB_USER -p$DB_PASSWORD --database -h 127.0.0.1 $db> $DumpFile echo "$db Dump Done" >> $LogFile tar czvf $GZDumpFile $DumpFile >> $LogFile 2>&1 echo "[$GZDumpFile]Backup Success!" >> $LogFile rm -f $DumpFile done #cd $BakDir/daily cd $BakDir echo "Backup Done!" echo "please Check $BakDir Directory!" echo "copy it to your local disk or ftp to somewhere !!!" /usr/bin/find $BakDir -ctime +10 -exec rm {} \; echo "delete file over 10 days"
文章链接:http://blog.zhengshuiguang.com/linux/mysql-bak.html
随便收藏,请保留本文地址!
评论已关闭