\t\t\t\t\u4f7f\u7528\u60c5\u5883\uff0c\u5e38\u614b\u6027\u7684\u5099\u4efd\u8cc7\u6599\u5eab\u5229\u7528shell script\uff1b\u9700\u642d\u914d\u6392\u7a0b\u4f7f\u7528\u3002
\n\u6b64\u70ba\u51b7\u5099\u4efd(\u975e\u505c\u7528\u6240\u6709\u8cc7\u6599\u5eab\u64cd\u4f5c)\u6240\u4ee5\u9084\u662f\u6709\u8cc7\u6599\u6d41\u5931\u7684\u53ef\u80fd\uff0c\u4f46\u5df2\u80fd\u5099\u63f4\u5927\u90e8\u4efd\u8cc7\u6599\u3002
\n\u8def\u5f91\uff1a\/home\/jeff\/public_html\/backup\/
\n\u65b0\u589e backup.sh \u6587\u4ef6\uff0c\u8f38\u5165\u4ee5\u4e0b\u8cc7\u6599
\n#!\/bin\/bash
\n#\u4ee5\u4e0a\u8a9e\u6cd5\u4e00\u5b9a\u8981\u52a0 \u624d\u80fd\u6b63\u78ba\u57f7\u884cshell script
\n#\u4e3b\u6a5f
\nHost=”localhost”
\n#\u4f7f\u7528\u8005
\nUser=”jeff”
\n#\u5bc6\u78bc
\nPass=”12345″
\n#\u8cc7\u6599\u5eab
\nDB=”jeffdb”
\n#\u5099\u4efd\u8def\u5f91 \u8a18\u5f97\u958b\u555f\u5beb\u5165\u6b0a\u9650
\nbackup_path=”\/home\/jeff\/public_html\/backup\/”
\n#\u62ff\u65e5\u671f\u7576\u90e8\u4efd\u6a94\u540d \u65b9\u4fbf\u65e5\u5f8c\u8b58\u5225
\ndate=$(date +”%Y%m%d”)
\n#sql\u6a94\u6848\u540d\u7a31 \u8a18\u5f97\u8b8a\u6578\u524d\u90fd\u8981\u52a0\u4e0a $
\nsql_name=$backup_path”DB”$date”.sql”
\n#\u6e2c\u8a66\u6642\u8b93\u4f60\u770b\u662f\u5426\u5df2\u7d93\u5728\u57f7\u884c\u5099\u4efd
\necho “mysqldump…”
\n#\u5099\u4efd\u8a9e\u6cd5 \u5c07\u4e0a\u9762\u7684\u53c3\u6578 \u5e36\u5165
\nmysqldump -h $Host -u $User -p$Pass $DB > $sql_name
\n#\u8f38\u51fasql\u6a94\u6848\u540d\u7a31 \u8868\u793a\u5099\u4efd\u5b8c\u6210
\necho $sql_name\t\t<\/p>\n","protected":false},"excerpt":{"rendered":"
\t\t\t\t\u4f7f\u7528\u60c5\u5883\uff0c\u5e38\u614b\u6027\u7684\u5099\u4efd\u8cc7\u6599\u5eab\u5229\u7528shell script\uff1b\u9700\u642d\u914d\u6392\u7a0b\u4f7f\u7528\u3002
\n\u6b64\u70ba\u51b7\u5099\u4efd(\u975e\u505c\u7528\u6240\u6709\u8cc7\u6599\u5eab\u64cd\u4f5c)\u6240\u4ee5\u9084\u662f\u6709\u8cc7\u6599\u6d41\u5931\u7684\u53ef\u80fd\uff0c\u4f46\u5df2\u80fd\u5099\u63f4\u5927\u90e8\u4efd\u8cc7\u6599\u3002\t\t<\/p>\n","protected":false},"author":1,"featured_media":1866,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[32,34],"tags":[133,136,405,511,678,1198],"class_list":["post-2533","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-linux","category-mysql","tag-backup","tag-bash","tag-mysqldump","tag-shell-script","tag-678","tag-1198","hvn-theme-has-thumbnail"],"_links":{"self":[{"href":"https:\/\/www.webteach.tw\/index.php?rest_route=\/wp\/v2\/posts\/2533","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.webteach.tw\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.webteach.tw\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.webteach.tw\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.webteach.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2533"}],"version-history":[{"count":0,"href":"https:\/\/www.webteach.tw\/index.php?rest_route=\/wp\/v2\/posts\/2533\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.webteach.tw\/index.php?rest_route=\/wp\/v2\/media\/1866"}],"wp:attachment":[{"href":"https:\/\/www.webteach.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2533"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.webteach.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2533"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.webteach.tw\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2533"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}