binlog\u5907\u4efd\u811a\u672c\u5982\u4e0b\uff1a<\/p>\n
binlogdir="\/mysql\/binlog";
\nbakbinlogdir="\/mysql\/binlogbak";
\ndateDIR=$(date -d "yesterday" +"%y-%m-%d")
\nmkdir -p ${bakbinlogdir}\/${dateDIR}<\/p>\n
mysqladmin -ubackup -ptest flush-logs<\/p>\n
TIME=$(date "-d 7 day ago" +"%Y-%m-%d %H:%M:%S")<\/p>\n
StartTime=$(date "-d -1 hours" +"%Y-%m-%d %H:%M:%S")<\/p>\n
mysql -ubackup -ptest -e "purge master logs before '${TIME}';"
\ncd ${bakbinlogdir}<\/p>\n
for db in $(mysql -ubackup -ptest -e "show databases" | grep -ve "Database" -ve "mysql" -ve "test" -ve "information_schema")
\ndo<\/p>\n
for log in $(cat ${binlogdir}\/binlog.index)
\ndo<\/p>\n
mysqlbinlog -ubackup -ptest -d $db --start-datetime="$StartTime" ${log}>>${bakbinlogdir}\/$dateDIR\/${db}${dateDIR} crontab config : 1 <\/em> <\/em> sh \/root\/databackup\/script\/mysql_binlog_bak.sh >>binlogbak.log 2>&1<\/p>\n \u8fd8\u539f\uff1a<\/p>\n cd \/mysql\/binlogbak\/15-03-03 \/\/\u53bb\u5907\u4efd\u7684\u76ee\u5f55 \u8fd8\u539f\uff1a \u6ce8\u610f\uff1a\u5982\u679c\u662f\u5907\u4efd\u7684binlog\u65e5\u5fd7\u6709\u5220\u9664\u8bed\u53e5\uff0c\u8fd8\u539f\u65f6\uff0c\u4e5f\u4f1a\u5220\u9664\u6570\u636e\u3002<\/p>\n","protected":false},"excerpt":{"rendered":" \u5907\u4efd\uff1a \u9996\u5148\u5f97\u5728my.cnf\u6587\u4ef6\u91cc\u52a0\u4e0a\uff1a log-bin=\/mysql\/binlog\/binlog expire_logs_days=7 \u91cd\u542fmysql\u670d\u52a1 service mysqld restart; binlog\u5907\u4efd\u811a\u672c\u5982\u4e0b\uff1a !\/bin\/bash binlogdir="\/mysql\/binlog"; bakbinlogdir="\/mysql\/binlogbak"; dateDIR=$(date -d "yesterday" +"%y-%m-%d") mkdir -p ${bakbinlogdir}\/${dateDIR} \u5237\u65b0\u7f13\u5b58\u4e2d\u7684\u65e5\u5fd7 mysqladmin -ubackup -ptest flush-logs 7\u5929\u524d\u7684\u65f6\u95f4 TIME=$(date "-d 7 day ago" +"%Y-%m-%d %H:%M:%S") 1\u5c0f\u65f6\u524d\u7684\u65f6\u95f4 StartTime=$(date "-d -1 hours" +"%Y-%m-%d %H:%M:%S") \u5220\u96647\u5929\u524d\u7684\u4e8c\u8fdb\u5236\u6587\u4ef6 mysql -ubackup -ptest -e "purge master logs before ‘${TIME}’;" cd ${bakbinlogdir} \u9488\u5bf9\u6bcf\u4e2a\u6570\u636e\u5e93 for db in $(mysql -ubackup -ptest -e "show databases" | grep -ve "Database" -ve "mysql" -ve "test" -ve "information_schema") do \u9488\u5bf9\u6240\u6709\u7684\u65e5\u5fd7\u6587\u4ef6 for log in $(cat ${binlogdir}\/binlog.index) do \u5907\u4efd\u6bcf\u4e2a\u6570\u636e\u5e931\u5c0f\u65f6\u4e4b\u524d\u5230\u73b0\u5728\u65f6\u95f4\u7684\u6240\u6709\u65e5\u5fd7\uff0c\u5199\u5165\u5230\u76f8\u5e94\u6587\u4ef6\u4e2d mysqlbinlog -ubackup -ptest -d $db –start-datetime="$StartTime" ${log}>>${bakbinlogdir}\/$dateDIR\/${db}${dateDIR} done tar jcvf ${bakbinlogdir}\/$dateDIR\/${db}${dateDIR}.tar.bz2 ${bakbinlogdir}\/$dateDIR\/${db}${dateDIR} 2&>\/dev\/null rm -rf ${bakbinlogdir}\/$dateDIR\/${db}${dateDIR} done \u5220\u966415\u5929\u4ee5\u524d\u7684\u589e\u91cf\u5907\u4efd\u6587\u4ef6\u548c\u76ee\u5f55 find ${bakbinlogdir}\/* -mtime +14 -type d -exec rm -rf {} \\; crontab config : 1 sh \/root\/databackup\/script\/mysql_binlog_bak.sh >>binlogbak.log 2>&1 \u8fd8\u539f\uff1a cd \/mysql\/binlogbak\/15-03-03 \/\/\u53bb\u5907\u4efd\u7684\u76ee\u5f55 tar -xvf qc_project_15-03-03.tar.bz2 \u8fd8\u539f\uff1a mysql -ubackup -ptest <qc_project_15-03-03 \u6ce8\u610f\uff1a\u5982\u679c\u662f\u5907\u4efd\u7684binlog\u65e5\u5fd7\u6709\u5220\u9664\u8bed\u53e5\uff0c\u8fd8\u539f\u65f6\uff0c\u4e5f\u4f1a\u5220\u9664\u6570\u636e\u3002<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":"","footnotes":""},"categories":[83],"tags":[],"class_list":["post-1396","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1396","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1396"}],"version-history":[{"count":1,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1396\/revisions"}],"predecessor-version":[{"id":1397,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1396\/revisions\/1397"}],"wp:attachment":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1396"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1396"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1396"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\ndone
\ntar jcvf ${bakbinlogdir}\/$dateDIR\/${db}<\/em>${dateDIR}.tar.bz2 ${bakbinlogdir}\/$dateDIR\/${db}${dateDIR} 2&>\/dev\/null
\nrm -rf ${bakbinlogdir}\/$dateDIR\/${db}<\/em>${dateDIR}
\ndone
\n\u5220\u966415\u5929\u4ee5\u524d\u7684\u589e\u91cf\u5907\u4efd\u6587\u4ef6\u548c\u76ee\u5f55
\nfind ${bakbinlogdir}\/* -mtime +14 -type d -exec rm -rf {} \\;<\/p>\n
\n
\ntar -xvf qc_project_15-03-03.tar.bz2 <\/p>\n
\nmysql -ubackup -ptest <qc_project_15-03-03<\/p>\n