????1.?????????????????????
????mkdir backup
????cd backup
????mkdir mysqlbackup
????cd mysqlbackup
????2.???????????
????vi mysqlautobackup
????3.??д?????
????filename=`date +%Y%m%d`
????/mysql??bin??/mysqldump --opt ??????? -u(mysql???) -p(mysql????) | gzip > /??????????/name$filename.gz
????????????????gzip?????name??????д?????-u??mysql????????п????????????-p??mysql????????
????4.???????????????????
????chmod +x autobackup
????5.д????????
????crontab -e
????01 01 * * * /bin/bash /?????????/mysqlautobackup
????????賿1????1????н????
??????????????
????/etc/rc.d/init.d/crond restart
???????????в?????ɡ?
?????Щ???ü???
????1?????????汸???????·??/mysqldata
????#mkdir /mysqldata
????2??????/usr/sbin/baktest???
?????????????????
????mysqldump -uroot -proot test | gzip > /mysqldata/test`date +%Y-%m-%d_%H%M%S`.sql.gz
????3??????????????????????
????#chmod +x /usr/sbin/baktest
????4?????/etc/crontab
?????????????
????01 3 * * * root /usr/sbin/baktest
??????????3????01????б???
????5?????????crond
????#/etc/rc.d/init.d/crond restart
??????ɡ?
????PS??
?????????????
????#!/bin/bash
????# Name:qbk???????
????# mysql qbk scripts
????# By zxsdw.com
????# Last Modify:2015-01-21
????#?????????·??
????#scriptsDir=/usr/sbin
????#???????????????
????user=root
????userPWD=????
????#???????????????
????database=?????
????#?????????????????·??
????bakDir=/backup/mysql
????#eMailFile=$bakDir/email.txt
????#eMail=admin@zxsdw.com
????#??????????
????LogFile=$bakDir/mysqlbak.log
????DATE=`date +%Y%m%d`
????echo " " >> $LogFile
????echo " " >> $LogFile
????echo "--------------------------" >> $LogFile
????echo $(date +"%y-%m-%d %H:%M:%S") >>$LogFile
????echo "-----------------" >> $LogFile
????cd $bakDir
????DumpFile=$DATE.sql.gz
????mysqldump --flush-logs -u$user -p$userPWD --quick $database| gzip >$DumpFile
????echo "Dump Done" >> $LogFile
????echo "[$DumpFile]Backup Success!" >> $LogFile
????daily_databakDir=$bakDir/daily_backup
????cd $bakDir/daily_backup
????find $daily_databakDir -name "daily*" -type f -mtime +35 -exec rm {} ; > /dev/null 2>&1