{"id":12081,"date":"2017-08-03T00:00:00","date_gmt":"2017-08-02T16:00:00","guid":{"rendered":"https:\/\/fgchen.com\/wpedu2\/2017\/08\/03\/%e4%b8%bb%e6%a9%9f%e7%9a%84%e7%a7%bb%e8%bd%89\/"},"modified":"2026-03-30T14:48:50","modified_gmt":"2026-03-30T06:48:50","slug":"%e4%b8%bb%e6%a9%9f%e7%9a%84%e7%a7%bb%e8%bd%89","status":"publish","type":"post","link":"https:\/\/fgchen.com\/wpedu\/2017\/08\/%e4%b8%bb%e6%a9%9f%e7%9a%84%e7%a7%bb%e8%bd%89\/","title":{"rendered":"\u4e3b\u6a5f\u7684\u79fb\u8f49"},"content":{"rendered":"<h2>\u4e00\u3001\u4e00\u884c\u6307\u4ee4\u8907\u88fdMySQL\u6240\u6709\u8cc7\u6599\u5eab\u5230\u65b0\u7684server<\/h2>\n\n<p style=\"padding-left: 30px\"><span style=\"font-size: 14pt\"><strong>mysqldump &#8211;all-databases -u[user] -p[pwd] | ssh user@[host\/IP] mysql -u[user] -p[pwd]<\/strong><\/span><\/p>\n\n<span style=\"font-size: 18pt\"><strong>\u8d85\u5f37\uff01<\/strong><\/span>\n\n<h2><span style=\"font-size: 18pt\">\u4e8c\u3001<strong>scp<\/strong>\u6307\u4ee4\u8907\u88fd\u6574\u500b\u76ee\u9304\u5230\u65b0\u7684Server\uff1a<\/span><\/h2>\n\n<span style=\"font-size: 14pt\"><strong>scp -rp sourcedirectory user@dest:\/path<\/strong><\/span>\n\n<h2><\/h2>\n\n<h2>\u4e09\u3001\u88dd\u5b8c httpd\u5f8c\u8981\u8655\u7406\u5e7e\u500b\u5730\u65b9<\/h2>\n\nconf.d\/userdir.conf\n\n<pre class=\"lang:xhtml decode:true\">&lt;IfModule mod_userdir.c&gt;\n    #\n    # UserDir is disabled by default since it can confirm the presence\n    # of a username on the system (depending on home directory\n    # permissions).\n    #\n    #UserDir disabled\n    #\n    # To enable requests to \/~user\/ to serve the user's public_html\n    # directory, remove the \"UserDir disabled\" line above, and uncomment\n    # the following line instead:\n    #\n    UserDir public_html\n&lt;\/IfModule&gt;<\/pre>\n\n&nbsp;\nhttpd.conf \u52a0\u4e0a\uff1a\n\n<pre class=\"lang:xhtml decode:true \">&lt;Directory \/home\/*\/public_html&gt;\n\u00a0 Options Indexes FollowSymLinks\n\u00a0 AllowOverride None\n\u00a0 Require all granted\n&lt;\/Directory&gt;<\/pre>\n\nSELinux\nchcon -R -t httpd_sys_content_t ~\/public_html\/\n\u95dc\u9589SeLinux\nsetenforce 0\n&nbsp;\nMy \u00a0Domain:\nhttp:\/\/kkhostdomain.supersite2.myorderbox.com\/","protected":false},"excerpt":{"rendered":"<p>\u4e00\u3001\u4e00\u884c\u6307\u4ee4\u8907\u88fdMySQL\u6240\u6709\u8cc7\u6599\u5eab\u5230\u65b0\u7684server mysqldump &#038;# &hellip; <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","fifu_image_url":"","fifu_image_alt":"","footnotes":""},"categories":[256],"tags":[],"class_list":["post-12081","post","type-post","status-publish","format-standard","hentry","category-256"],"_links":{"self":[{"href":"https:\/\/fgchen.com\/wpedu\/wp-json\/wp\/v2\/posts\/12081","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fgchen.com\/wpedu\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fgchen.com\/wpedu\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fgchen.com\/wpedu\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fgchen.com\/wpedu\/wp-json\/wp\/v2\/comments?post=12081"}],"version-history":[{"count":1,"href":"https:\/\/fgchen.com\/wpedu\/wp-json\/wp\/v2\/posts\/12081\/revisions"}],"predecessor-version":[{"id":13501,"href":"https:\/\/fgchen.com\/wpedu\/wp-json\/wp\/v2\/posts\/12081\/revisions\/13501"}],"wp:attachment":[{"href":"https:\/\/fgchen.com\/wpedu\/wp-json\/wp\/v2\/media?parent=12081"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fgchen.com\/wpedu\/wp-json\/wp\/v2\/categories?post=12081"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fgchen.com\/wpedu\/wp-json\/wp\/v2\/tags?post=12081"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}