{"id":343,"date":"2024-04-04T10:42:29","date_gmt":"2024-04-04T02:42:29","guid":{"rendered":"http:\/\/blue.yn.cn\/?p=343"},"modified":"2024-05-26T10:16:01","modified_gmt":"2024-05-26T02:16:01","slug":"%e5%90%8c%e6%ad%a5wordpress%e6%96%87%e7%ab%a0","status":"publish","type":"post","link":"http:\/\/blue.yn.cn\/?p=343","title":{"rendered":"\u540c\u6b65wordpress\u6587\u7ae0"},"content":{"rendered":"<h3>\u901a\u8fc7\u66ff\u6362\u6570\u636e\u5e93wordpress<\/h3>\n<h4>\u540c\u6b65\u7f51\u7ad9\u5a92\u4f53<\/h4>\n<ul>\n<li>\u589e\u91cf\u540c\u6b65\u5a92\u4f53\u5e93\u6587\u4ef6(\u63a8)<br \/>\n<code>rsync -avz \/website\/wordpress\/wp-content\/uploads root@139.199.79.133:\/website\/wordpress\/wp-content\/ <\/code><\/p>\n<ul>\n<li>\u5982\u679c\u662f\u540c\u6b65<code>uploads<\/code>\u8fd9\u4e2a\u76ee\u5f55\uff0c<code>uploads<\/code>\u540e\u9762\u4e0d\u80fd\u6709<code>\/<\/code>\uff0c\u6709<code>\/<\/code>\u5c31\u662f\u540c\u6b65<code>uploads<\/code>\u4e0b\u9762\u7684\u6587\u4ef6\u8fc7\u53bb<\/li>\n<li><code>rsync<\/code>\u662f\u589e\u91cf\u540c\u6b65\uff0c\u6e90\u6587\u4ef6\u4fee\u6539\u6216\u65b0\u589e\u7684\u624d\u4f1a\u540c\u6b65\uff1b\u5982\u679c\u76ee\u7684\u6587\u4ef6\u5220\u4e86\uff0c\u662f\u4e0d\u4f1a\u540c\u6b65\u8fc7\u53bb\u7684\u3002\u53ef\u4ee5\u4f7f\u7528scp\u5168\u91cf\u540c\u6b65<br \/>\n<code>scp -rp \/website\/wordpress\/wp-content\/uploads root@139.199.79.133:\/website\/wordpress\/wp-content\/ <\/code><\/li>\n<li><code>scp -p<\/code><code>-p Preserves modification times, access times, and modes from the original file.<\/code>\u53ea\u662f\u4fdd\u7559\u539f\u6587\u4ef6\u7684\u4fee\u6539\u65f6\u95f4\uff0c\u8bbf\u95ee\u65f6\u95f4\u548c\u6743\u9650\uff0c\u4e0d\u80fd\u4fdd\u7559\u5c5e\u7ec4\u5c5e\u4e3b\uff0c<br \/>\n<code>chown -R www.www uploads\/<\/code><\/li>\n<li><em>\u4ee5\u540e\u6709\u7a7a\u505a\u6210\u89e6\u53d1\u5b9e\u65f6\u589e\u91cf\u540c\u6b65<\/em><\/li>\n<li>\u5b9e\u73b0\u4e86\u7b2c\u4e00\u6b65\u5b88\u62a4\u8fdb\u7a0b\u65b9\u5f0f<br \/>\n<code>rsync -avz \/website\/wordpress\/wp-content\/uploads --password-file=\/etc\/rsync.pass rsync_backup@139.199.79.133::uploads <\/code><\/li>\n<li>\u76f4\u63a5\u628a\u5a92\u4f53\u5e93\u76ee\u5f55\u6302\u8f7d\u5230nfs\u4e0d\u662f\u66f4\u597d\uff1f<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h4>\u66ff\u6362ip\u5730\u5740<\/h4>\n<ul>\n<li>\n<p>\u7528<code>phpmyadmin<\/code>\u672c\u5730\u6570\u636e\u5e93\u5bfc\u51fa<code>wp_posts<\/code>\u8868\u5230\u817e\u8baf\u4e91\u7684\u6570\u636e\u5e93\uff1b<code>wp_posts<\/code>\u8868\u7684<code>post_content\u3001guid<\/code>\u5b57\u6bb5\u4f7f\u7528\u641c\u7d22--&gt;\u67e5\u627e\u66ff\u6362\u529f\u80fd\uff0c\u628ablue.yn.cn\u66ff\u6362\u4e3a139.199.79.133<\/p>\n<\/li>\n<li>\n<p>\u5b9e\u73b0\u6dfb\u52a0\u8bc4\u8bba\u81ea\u52a8\u89e6\u53d1ip\u5730\u5740\u66ff\u6362<br \/>\n\u5229\u7528<code>phpmyadmin<\/code>\u5728<code>wp_comments<\/code>\u8868\u6dfb\u52a0\u4e24\u4e2a\u89e6\u53d1\u5668<br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2024\/04\/image-1712323366396.png\" alt=\"file\" \/><\/p>\n<pre><code class=\"language-sql\">UPDATE `wp_posts` SET `post_content` = REPLACE(`post_content`, &#039;blue.yn.cn&#039;, &#039;139.199.79.133&#039;) WHERE `post_content` LIKE &#039;%blue.yn.cn%&#039; COLLATE utf8mb4_bin\nUPDATE `wp_posts` SET `guid` = REPLACE(`guid`, &#039;blue.yn.cn&#039;, &#039;139.199.79.133&#039;) WHERE `guid` LIKE &#039;%blue.yn.cn%&#039; COLLATE utf8mb4_bin<\/code><\/pre>\n<\/li>\n<li>\n<p>\u8fd8\u6709\u6587\u7ae0\u7f16\u8f91\u5b57\u6bb5post_content_filtered\u9700\u8981\u66f4\u6362<code>ip<\/code>\u5730\u5740<br \/>\n\u518d\u6dfb\u52a0\u4e00\u4e2a\u89e6\u53d1\u5668,\u5f53\u5220\u9664\u8bc4\u8bba\u65f6\u66ff\u6362<\/p>\n<pre><code class=\"language-sql\">UPDATE `wp_posts` SET `post_content_filtered` = REPLACE(`post_content_filtered`, &#039;blue.yn.cn&#039;, &#039;139.199.79.133&#039;) WHERE `post_content_filtered` LIKE &#039;%blue.yn.cn%&#039; COLLATE utf8mb4_bin<\/code><\/pre>\n<\/li>\n<li>\n<p>\u5916\u89c2--&gt;\u83dc\u5355--&gt;\u9996\u9875\uff1a\u81ea\u5b9a\u4e49\u7684\u94fe\u63a5\u7f51\u5740\u6539\u4e3a<code>http:\/\/blue.yn.cn<\/code><\/p>\n<\/li>\n<li>\n<p>\u8bbe\u7f6e--&gt;\u5e38\u89c4\uff1a<code>WordPress \u5730\u5740\uff08URL\uff09<\/code>\u548c<code>\u7ad9\u70b9\u5730\u5740\uff08URL\uff09<\/code>\u8be5\u4e3a<code>http:\/\/blue.yn.cn<\/code><\/p>\n<\/li>\n<\/ul>\n<h4>\u9875\u9762\u56fe\u7247<\/h4>\n<p>\u5916\u89c2--&gt;\u9875\u9762\uff1a\u56fe\u7247\u9009\u62e9<code>fengche1.jpg<\/code><\/p>\n<h3>\u901a\u8fc7\u66ff\u6362wp_posts\u8868<\/h3>\n<p>\u66ff\u6362\u5b8c\u6210<code>wp_posts<\/code>\u8868\u540e\uff0c\u8bb0\u5f97\u66f4\u597d\u8868\u4e2d\u76f8\u5173\u5b57\u6bb5\u7684<code>ip<\/code>\u5730\u5740<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u901a\u8fc7\u66ff\u6362\u6570\u636e\u5e93wordpress \u540c\u6b65\u7f51\u7ad9\u5a92\u4f53 \u589e\u91cf\u540c\u6b65\u5a92\u4f53\u5e93\u6587\u4ef6(\u63a8) rsync -avz \/websit&#8230; &raquo; <a class=\"read-more-link\" href=\"http:\/\/blue.yn.cn\/?p=343\">\u9605\u8bfb\u5168\u6587<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":["post-343","post","type-post","status-publish","format-standard","hentry","category-mariadb"],"_links":{"self":[{"href":"http:\/\/blue.yn.cn\/index.php?rest_route=\/wp\/v2\/posts\/343","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/blue.yn.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blue.yn.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blue.yn.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/blue.yn.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=343"}],"version-history":[{"count":24,"href":"http:\/\/blue.yn.cn\/index.php?rest_route=\/wp\/v2\/posts\/343\/revisions"}],"predecessor-version":[{"id":348,"href":"http:\/\/blue.yn.cn\/index.php?rest_route=\/wp\/v2\/posts\/343\/revisions\/348"}],"wp:attachment":[{"href":"http:\/\/blue.yn.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=343"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blue.yn.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=343"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blue.yn.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=343"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}