{"id":1267,"date":"2009-07-25T11:50:04","date_gmt":"2009-07-25T03:50:04","guid":{"rendered":"http:\/\/www.lmyoaoa.com\/inn\/?p=1267"},"modified":"2011-07-16T00:41:59","modified_gmt":"2011-07-15T16:41:59","slug":"wp%e6%8d%a2%e7%9b%ae%e5%bd%95%e5%90%8e%e5%9b%be%e7%89%87%e6%97%a0%e6%b3%95%e4%b8%8a%e4%bc%a0%e5%8f%8a%e7%9b%b8%e5%85%b3%e9%97%ae%e9%a2%98%e8%a7%a3%e5%86%b3%e5%8a%9e%e6%b3%95-2","status":"publish","type":"post","link":"http:\/\/www.lmyoaoa.com\/inn\/archives\/1267\/","title":{"rendered":"WP\u6362\u76ee\u5f55\u540e\u56fe\u7247\u65e0\u6cd5\u4e0a\u4f20\u53ca\u76f8\u5173\u95ee\u9898\u89e3\u51b3\u529e\u6cd5"},"content":{"rendered":"

\"wentiwenti\"<\/a><\/p>\n

\u65e9\u4e0a8\u70b9\u5c31\u5f6a\u8d77\u6765\u4e86\uff0c\u867d\u7136\u6628\u665a\u5f04\u52303\u70b9\u591a\u53d7\u4e0d\u4e86\u624d\u7761\u4e0b\uff0c\u5c31\u56e0\u4e3a\u4e00\u4e2a\u539f\u56e0\uff0c\u56fe\u7247\u65e0\u6cd5\u4e0a\u4f20\u4e86…google\u5f88\u5f88\u591a\u5173\u952e\u8bcd\uff0c\u4f46\u662f\u4e00\u70b9\u7528\u90fd\u6ca1\u6709\uff0c\u4e5f\u5c31\u662f\u5b8c\u5168\u6ca1\u627e\u5230\u6709\u8bf4\u6362\u57df\u540d\u6216\u76ee\u5f55\u540e\u65e0\u6cd5\u4e0a\u4f20\u56fe\u7247\u7684\u76f8\u5173\u95ee\u9898\u3002\u722c\u8d77\u6765\u81ea\u5df1\u53c8\u53bb\u6570\u636e\u5e93\u554a\u4ec0\u4e48\u7684\u770b\u5230\u5e95\u91cc\u9762\u6709\u6ca1\u6709\u6211\u4e0a\u4f20\u7684\u8bb0\u5f55\uff0c\u53d1\u73b0\u6709\u8bb0\u5f55…= =b\u6211\u56e7\u4e86…<\/p>\n

\u65e9\u4e0a\u88abdecmes\u540c\u5b66\u63d0\u9192\uff0c\u53d1\u73b0\u8868\u60c5\u5c45\u7136Orz\u5730\u5168\u90e8\u90fd\u53d8\u6210\u9ed8\u8ba4\u8868\u60c5\u4e86.. \":tt\"<\/p>\n

\u641e\u5b9a\u8868\u60c5\u540e\u628a\u4e0a\u4f20\u7684\u95ee\u9898\u89e3\u51b3\u4e86\uff0c\u539f\u6765\u662f\u4e0a\u4f20\u8def\u5f84\u7684\u95ee\u9898\uff0c\u53ea\u8981\u5728\u540e\u53f0\u91cc\u7684\u8bbe\u7f6e->\u6742\u9879\u91cc\u4fee\u6539\u4e0b\u8def\u5f84\u5c31\u597d\u4e86<\/p>\n

\"32423423421\"<\/a><\/p>\n

\u5bf9\u4e86\uff0c\u6211\u987a\u9053\u628aWP\u7a0b\u5e8f\u5347\u7ea7\u52302.82\u4e86….\u4f46\u662f\u53c8\u53d1\u73b0\u540e\u53f0\u7684HTML\u7f16\u8f91\u65e0\u6cd5\u4f7f\u7528\uff0c\u8868\u60c5\u4e5f\u65e0\u6cd5\u76f4\u63a5\u5728\u540e\u53f0\u6dfb\u52a0\u4e86\uff0c\u6cea\u554a\uff0c\u600e\u4e48\u7a81\u7136\u51fa\u8fd9\u4e48\u591a\u95ee\u9898..<\/p>\n

\u8fd8\u6709\u6628\u5929\u665a\u4e0a\u6362\u57df\u540d\u7684\u4e00\u4e9bSQL\u8bed\u53e5\u505a\u4e2a\u8bb0\u5f55\uff0c\u6ca1\u65f6\u95f4\u4e86\uff0c\u76f4\u63a5\u590d\u5236\u8fc7\u6765\uff1a<\/p>\n

\u4fee\u6539option_value\u91cc\u7684\u7ad9\u70b9url\u548c\u4e3b\u9875\u5730\u5740\uff1a<\/p>\n

\n

\u4fee\u6539option_value\u91cc\u7684\u7ad9\u70b9url\u548c\u4e3b\u9875\u5730\u5740\uff1a<\/p>\n

UPDATE wp_options SET option_value = replace(option_value, 'http:\/\/www.old-domain.com', 'http:\/\/www.new-domain.com') WHERE option_name = 'home' OR option_name = 'siteurl';<\/code><\/p>\n

\u66f4\u6b63\u6587\u7ae0\u4e2d\u5185\u90e8\u94fe\u63a5\u53ca\u9644\u4ef6\u7684\u5730\u5740\uff1a<\/p>\n

UPDATE wp_posts SET post_content = replace(post_content, 'http:\/\/www.old-domain.com', 'http:\/\/www.new-domain.com');<\/code><\/p>\n

\u66f4\u6b63wordpress\u6587\u7ae0\u9ed8\u8ba4\u7684\u6c38\u4e45\u94fe\u63a5\uff1a

UPDATE wp_posts SET guid = replace(guid, 'http:\/\/www.old-domain.com','http:\/\/www.new-domain.com');<\/code><\/p>\n<\/blockquote>\n

\u5176\u5b9e\u6709\u4e9b\u76f4\u63a5\u7528phpadmin\u6765\u6539\u5c31\u53ef\u4ee5\u4e86= =<\/p>\n

\u521a\u521a\u53d1\u8868\u7684\u6587\u7ae0\u5c45\u7136\u6ca1\u6709\u5185\u5bb9\uff0c\u8fd9\u53c8\u662f\u4ec0\u4e48\u95ee\u9898\u554a\uff0c\u597d\u591a\u4e71\u4e03\u516b\u7cdf\u7684\u95ee\u9898\uff0c\u800c\u4e14\u6211\u5927\u59d1\u59d1\u6765\u6211\u5bb6\u4e86\uff0c\u8981\u62db\u5f85\u5ba2\u4eba\uff0c\u7b49\u4e0b\u5403\u5b8c\u996d\u4e0b\u5348\u8fd8\u6709\u6d3b\u8981\u5e72\uff0c\u554a\u554a\u554a\u554a\u554a\uff0c\u5934\u597d\u5927\u554a\uff01\u665a\u4e0a\u56de\u6765\u518d\u641e\u5b9a\u5176\u4ed6\u95ee\u9898\u4e86.. \":twisted:\"<\/p>\n","protected":false},"excerpt":{"rendered":"

\u65e9\u4e0a8\u70b9\u5c31\u5f6a\u8d77\u6765\u4e86\uff0c\u867d\u7136\u6628\u665a\u5f04\u52303\u70b9\u591a\u53d7\u4e0d\u4e86\u624d\u7761\u4e0b\uff0c\u5c31\u56e0\u4e3a\u4e00\u4e2a\u539f\u56e0\uff0c\u56fe\u7247\u65e0\u6cd5\u4e0a\u4f20\u4e86…google\u5f88 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[363,364],"class_list":["post-1267","post","type-post","status-publish","format-standard","hentry","category-technology","tag-wp","tag-364"],"_links":{"self":[{"href":"http:\/\/www.lmyoaoa.com\/inn\/wp-json\/wp\/v2\/posts\/1267","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.lmyoaoa.com\/inn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.lmyoaoa.com\/inn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.lmyoaoa.com\/inn\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.lmyoaoa.com\/inn\/wp-json\/wp\/v2\/comments?post=1267"}],"version-history":[{"count":2,"href":"http:\/\/www.lmyoaoa.com\/inn\/wp-json\/wp\/v2\/posts\/1267\/revisions"}],"predecessor-version":[{"id":3997,"href":"http:\/\/www.lmyoaoa.com\/inn\/wp-json\/wp\/v2\/posts\/1267\/revisions\/3997"}],"wp:attachment":[{"href":"http:\/\/www.lmyoaoa.com\/inn\/wp-json\/wp\/v2\/media?parent=1267"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.lmyoaoa.com\/inn\/wp-json\/wp\/v2\/categories?post=1267"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.lmyoaoa.com\/inn\/wp-json\/wp\/v2\/tags?post=1267"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}