`\u5907\u4efd\u811a\u672c\uff1a
\n-rwxr-xr-x 1 root root 57 2015-05-18 17:27 databaselist.txt
\nYFCS-4-DBWAS:~\/databackup\/script # more backmysqldatabase.sh <\/p>\n
####################################################<\/p>\n
####################################################<\/p>\n
#############default parameter define################## #############receive parameter ######################## if [ $# -eq 1 ] ;then #############receive parameter end#####################<\/p>\n test ! -d ${backfiledirtmp} && mkdir -p ${backfiledirtmp} ############Backup and compression function############ ############Backup and compression function end ######### if [ ! -f "${databaselist}" ] #############ftp backdatefiles to backhost ########## EOF #############move backfile to backdir ########## #############purge backdatefiles 8 days ago########## YFCS-4-DBWAS:~\/databackup\/script # more restore_mysql.sh <\/p>\n ####################################################<\/p>\n ####################################################<\/p>\n #############default parameter define################## #############default parameter define end##############<\/p>\n #############receive parameter ########################<\/p>\n if [ $# -eq 1 ] ;then #############receive parameter end#####################<\/p>\n backfiledir= if [ ! -d "${backfiledir}" ] cd ${backfiledir}<\/p>\n if [ ! -f "${backfilename}" ] mysql -u${username} -p${password} -h${host} -P${port} -D $databasename --default-character-set=utf8 <"${unzipfile}" #############restore end#####################<\/p>\n YFCS-4-DBWAS:~\/databackup\/script # `<\/p>\n","protected":false},"excerpt":{"rendered":" `\u5907\u4efd\u811a\u672c\uff1a -rwxr-xr-x 1 root root 57 2015-05-18 17:27 databaselist.txt YFCS-4-DBWAS:~\/databackup\/script # more backmysqldatabase.sh !\/bin\/bash #################################################### author:newhackerman \u4f7f\u7528\u8bf4\u660e\uff1a \u9996\u5148\u5728\u5907\u4efd\u811a\u672c\u6240\u5728\u8def\u5f84\u4e0b\u65b0\u5efa\u6587\u4ef6databaselist.txt \u5e76\u628a\u8981\u5907\u4efd\u7684\u6570\u636e\u5e93\u5199\u5165\u5176\u4e2d\uff0c\u4e00\u884c\u4e00\u4e2a\u6570\u636e\u5e93\u540d\u79f0 \u6267\u884c\uff1a sh backmysqldatabase.sh &\u8fdb\u884c\u5168\u5e93\u5907\u4efd \u53ef\u4f20\u5165\u53c2\u6570 \u7528\u6237\u540d\uff0c\u5bc6\u7801\uff0c\u6570\u636e\u5e93\u540d\u79f0\uff0c\u5907\u4efd\u8def\u5f84\uff0c\u4e3b\u673a\uff0c\u7aef\u53e3 usage:backmysqldatabase.sh backup test zentao \/root\/databackup localhost 3306& \u4f20\u53c2\u8fdb\u884c\u5355\u5e93\u5907\u4efd\uff0c\u672a\u4f20\u53c2\u5219\u5168\u5e93\u5907\u4efd #################################################### #############default parameter define################## username="backup" password="test" databasename="zentao" host="localhost" port="3306" backfiledir="\/root\/databackup" Tdate=date "+%Y-%m-%d-%H" Ttime=MARKDOWN_HASHcce46cdaa704d445e6fd494cfb8782deMARKDOWNHASH backfiledirtmp="\/root\/databackup\/tmp" scriptdir="\/root\/databackup\/script" databaselist="${scriptdir}\/databaselist.txt" logfile="${backfiledirtmp}\/back${Tdate}-${Ttime}.log" backfilename="$databasename$back$Tdate.sql" rundumppath=\/usr\/local\/mysql\/bin #############default parameter define end############## mysqldump -u${username} -p{password} –databases zentao -h localhost -P3306 –opt –single-transaction –skip-lock-tables >\/root\/databackup\/zentao_back_20150203.sql #############receive parameter ######################## #############receive parameter ######################## if [ $# -eq 1 ] ;then username=$1 echo "$1" elif [ $# -eq 2 ] ;then username=$1 password=$2 echo "$1—-$2" elif [ $# -eq 3 ] ;then username=$1 password=$2 databasename=$3 elif [ $# -eq 4 ] ;then username=$1 password=$2 databasename=$3 backfiledir=$4 elif [ $# -eq 5 ] ;then username=$1 password=$2 databasename=$3 backfiledir=$4 host=$5 elif [ $# -eq 6 ] ;then username=$1 password=$2 databasename=$3 backfiledir=$4 host=$5 port=$6 elif [ $# -gt 6 ] ;then echo "input parameters error please check it "…<\/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-1392","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1392","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=1392"}],"version-history":[{"count":1,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1392\/revisions"}],"predecessor-version":[{"id":1393,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1392\/revisions\/1393"}],"wp:attachment":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1392"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1392"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1392"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nusername="backup"
\npassword="test"
\ndatabasename="zentao"
\nhost="localhost"
\nport="3306"
\nbackfiledir="\/root\/databackup"
\nTdate=date "+%Y-%m-%d-%H"<\/code>
\nTtime=MARKDOWN_HASHcce46cdaa704d445e6fd494cfb8782deMARKDOWNHASH<\/code>
\nbackfiledirtmp="\/root\/databackup\/tmp"
\nscriptdir="\/root\/databackup\/script"
\ndatabaselist="${scriptdir}\/databaselist.txt"
\nlogfile="${backfiledirtmp}\/back<\/em>${Tdate}-${Ttime}.log"
\nbackfilename="$databasename$back<\/em>$Tdate.sql"
\nrundumppath=\/usr\/local\/mysql\/bin
\n#############default parameter define end##############<\/p>\nmysqldump -u${username} -p{password} --databases zentao -h localhost -P3306 --opt --single-transaction --skip-lock-tables >\/root\/databackup\/zentao_back_20150203.sql<\/h1>\n
\n#############receive parameter ########################<\/p>\n
\nusername=$1
\necho "$1"
\nelif [ $# -eq 2 ] ;then
\nusername=$1
\npassword=$2
\necho "$1----$2"
\nelif [ $# -eq 3 ] ;then
\nusername=$1
\npassword=$2
\ndatabasename=$3
\nelif [ $# -eq 4 ] ;then
\nusername=$1
\npassword=$2
\ndatabasename=$3
\nbackfiledir=$4
\nelif [ $# -eq 5 ] ;then
\nusername=$1
\npassword=$2
\ndatabasename=$3
\nbackfiledir=$4
\nhost=$5
\nelif [ $# -eq 6 ] ;then
\nusername=$1
\npassword=$2
\ndatabasename=$3
\nbackfiledir=$4
\nhost=$5
\nport=$6
\nelif [ $# -gt 6 ] ;then
\necho "input parameters error please check it " >>${logfile}
\nelse
\necho "not input parameter use all default parameters !" >>${logfile}
\nfi<\/p>\n
\ntest ! -d ${backfiledir} && mkdir -p ${backfiledir}
\ncd ${backfiledirtmp}<\/p>\n
\nfunction BackDatabase(){<\/p>\ncd ${backfiledir}<\/h1>\n
logfile=\"${backfiledirtmp}\/${databasename}_back_${Tdate}-${Ttime}.log\"\n echo date "+%Y-%m-%d %X"<\/code> >>${logfile}\n echo \"begin backup $databasename\" >>${logfile}\n $rundumppath\/mysqldump -u${username} -p${password} -h${host} -P${port} --databases $databasename --opt --default-character-set=utf8 --single-transaction --skip-lock-tables >\"$backfiledirtmp\/${databasename}_back_${Tdate}.sql\"\n\n if [[ -f \"${backfiledirtmp}\/${databasename}_back_${Tdate}.sql\" ]] && [[ -s \"${backfiledirtmp}\/${databasename}_back_${Tdate}.sql\" ]]\n then\n echo date "+%Y-%m-%d %X"<\/code> >>${logfile}\n echo \" backup $databasename sucess!\" >>${logfile}\n #############bengin to compress #####################\n if [ -f \"${backfiledirtmp}\/${databasename}_back_${Tdate}.sql\" ]\n then\n gzip \"${backfiledirtmp}\/${databasename}_back_${Tdate}.sql\"\n if [ -f \"${backfiledirtmp}\/${databasename}_back_${Tdate}.sql.gz\" ]\n then\n echo \" compress $databasename sucess!\" >>${logfile}\n else\n echo \" compress $databasename fail !\" >>${logfile}\n fi\n fi\n #############compress end #####################\n else\n echo \" backup ${databasename} fail!\" >>${logfile}\n #mail -s \"data backup fail\" zoujiayong@revenco.com
\n############run back start #########
\nif [ $# -eq 0 ] ;then<\/p>\n
\nthen
\necho " ${databaselist} file not exsit!" >>${logfile}
\nexit
\nfi
\ncat $databaselist|while read databasename #\u4e00\u6b21\u8bfb\u53d6\u4e00\u4e2a\u6570\u636e\u5e93\u8fdb\u884c\u5907\u4efd
\ndo
\nlogfile="${backfiledirtmp}\/${databasename}back<\/em>${Tdate}-${Ttime}.log"
\nBackDatabase; #\u5faa\u73af\u8fdb\u884c\u5907\u4efd
\ndone
\nelif [ $# -lt 7 ] ;then
\nBackDatabase
\nelse
\necho "input parameter is error please check it!" >>${logfile}
\nfi
\n############run back end #########<\/p>\n
\nfunction CopyZfileToDhost(){
\nftpuser=zjy
\nftppass=zjy
\nftphost="10.200.5.201"
\nftpDdir="\/home\/zjy\/jmeter"<\/p>\nftpDdir="\/backup\/atp_qc_projectbak"<\/h1>\n
#backfiledirtmp=\"\/root\/databackup\"\n cd ${backfiledirtmp}\n #sftp root@10.200.25.151 <
\n}
\nCopyZfileToDhost;
\n#############ftp end ##########<\/p>\n
\ncd ${backfiledirtmp};
\nmv ${backfiledirtmp}\/*.gz ${backfiledir}\/
\n#############move end ##########<\/p>\n
\ncdate=8
\nfind ${backfiledir} -mtime +${cdate} -name ".gz" >>"${logfile}";
\nfind ${backfiledir} -mtime +${cdate} -name "<\/em>.gz" -exec rm -rf {} \\;
\necho " delete ${cdate} backdatafile sucess!" >>"${logfile}"
\n#############purge end #####################<\/p>\n20 1 <\/em> 1,2,3,4,5,6 sh \/root\/databackup\/script\/backup_alldatabases.sh backup test zentao \/root\/databackup &<\/h1>\n
\n\u6062\u590d\u811a\u672c\uff1a<\/h1>\n
!\/bin\/bash<\/h1>\n
author:zoujiayong<\/h2>\n
\u4f7f\u7528\u8bf4\u660e\uff1a<\/h2>\n
\u6267\u884c\uff1a sh restore_mysql.sh &\u8fdb\u884c\u6062\u590d<\/h2>\n
\u53ef\u4f20\u5165\u53c2\u6570 \u7528\u6237\u540d\uff0c\u5bc6\u7801\uff0c\u6570\u636e\u5e93\u540d\u79f0\uff0c\u5907\u4efd\u8def\u5f84\u53ca\u6587\u4ef6<\/h2>\n
usage:restore_mysql.sh backup test zentao \/root\/databackup\/zentao_back_2015-02-04-10.sql.gz<\/h2>\n
\nusername=backup
\npassword=test
\ndatabasename="mysql"
\nhost=localhost
\nport=3306
\nTdate=date "+%Y-%m-%d-%H"<\/code>
\nTtime=date +%M-%S<\/code>
\nbackdata="\/root\/databackup\/zentao_back_2015-02-04-10.sql.gz"
\nbackfiledir=echo ${backdata%\/*}<\/code> #\u622a\u53d6\u8def\u5f84
\nbackfilename=echo ${backdata##*\/}<\/code> #\u622a\u53d6\u540d\u79f0
\nbackfiledirtmp="\/root\/databackup\/tmp"
\nscriptdir=MARKDOWN_HASH9003d1df22eb4d3820015070385194c8MARKDOWNHASH<\/code>
\ndatabaselist="${scriptdir}\/databaselist.txt"
\nlogfile="${backfiledirtmp}\/restore<\/em>${Tdate}-${Ttime}.log"<\/p>\nbackfilename=$databasename$back<\/em>$Tdate.sql<\/h1>\n
\nusername=$1
\necho "$1"
\nelif [ $# -eq 2 ] ;then
\nusername=$1
\npassword=$2
\necho "$1----$2"
\nelif [ $# -eq 3 ] ;then
\nusername=$1
\npassword=$2
\ndatabasename=$3
\nelif [ $# -eq 4 ] ;then
\nusername=$1
\npassword=$2
\ndatabasename=$3
\nbackdata=$4
\nelif [ $# -eq 5 ] ;then
\nusername=$1
\npassword=$2
\ndatabasename=$3
\nbackdata=$4
\nhost=$5
\nelif [ $# -eq 6 ] ;then
\nusername=$1
\npassword=$2
\ndatabasename=$3
\nbackdata=$4
\nhost=$5
\nport=$6
\nelif [ $# -gt 6 ] ;then
\necho "input parameters error please check it " >>${logfile}
\nelse
\necho "not input parameter use all default parameters !" >>${logfile}
\nfi<\/p>\necho ${backdata%\/*}<\/code> #\u622a\u53d6\u8def\u5f84
\nbackfilename=echo ${backdata##*\/}<\/code> #\u622a\u53d6\u540d\u79f0<\/p>\n
\nthen
\necho " ${backfiledir} dir not exsit!" >>${backfiledirtmp}\/${databasename}restore<\/em>${Tdate}-${Ttime}.log
\nfi
\n#############restore start #####################<\/p>\n
\nthen
\necho " ${backfilename} file not exsit!" >>${backfiledirtmp}\/${databasename}restore<\/em>${Tdate}-${Ttime}.log
\nexit
\nelse
\ncp ${backfiledir}\/${backfilename} ${backfiledirtmp}\/
\ncd "${backfiledirtmp}\/"
\ngunzip "${backfilename}"
\nunzipfile=echo ${backfilename%.*}<\/code> #\u83b7\u53d6\u89e3\u538b\u7f29\u540e\u7684\u6587\u4ef6\u540d
\nfi
\necho date "+%Y-%m-%d %X"<\/code> >>${backfiledirtmp}\/${databasename}restore<\/em>${Tdate}-${Ttime}.log<\/p>\n
\nrm "${unzipfile}"
\necho date "+%Y-%m-%d %X"<\/code> >>${backfiledirtmp}\/${databasename}restore<\/em>${Tdate}-${Ttime}.log
\necho " restore sucess" >>${backfiledirtmp}\/${databasename}restore<\/em>${Tdate}-${Ttime}.log<\/p>\n