WordPress\u5c06\u5176\u6240\u6709\u4fe1\u606f\u7247\u6bb5\uff08\u5305\u62ec\u6587\u7ae0\u3001\u9875\u9762\u3001\u8bc4\u8bba\u3001\u535a\u5ba2\u94fe\u63a5\u3001\u63d2\u4ef6\u8bbe\u7f6e\u7b49\uff09\u5b58\u50a8\u5728MySQL\u6570\u636e\u5e93\u4e2d\u3002 \u867d\u7136WordPress\u7528\u6237\u53ef\u4ee5\u901a\u8fc7\u7f51\u7ad9\u540e\u53f0\u7f16\u8f91\u63a7\u5236\u4ee5\u4e0a\u4fe1\u606f\u7247\u6bb5\u3002 \u5728\u4e00\u5b9a\u7a0b\u5ea6\u4e0a\u3002<\/p>\n
\u4e0d\u8fc7\u5047\u8bbe\u4f60\u7684WordPress\u7f51\u7ad9\u4e0a\u6709\u6210\u767e\u4e0a\u5343\u7bc7\u6587\u7ae0\uff0c\u800c\u4f60\u9700\u8981\u8fdb\u884c\u5168\u7ad9\u8303\u56f4\u7684\u6539\u52a8\uff0c \u8fd9\u65f6\u4ece\u540e\u53f0\u9010\u6761\u7f16\u8f91\u5c31\u6709\u70b9\u8d39\u65f6\u8d39\u529b\u4e86\uff0c\u5e76\u4e14\u72af\u9519\u7684\u51e0\u7387\u4e5f\u4f1a\u63d0\u9ad8\u3002 \u6700\u597d\u7684\u65b9\u6cd5\u662f\u8fdb\u5165WordPress\u7684MySQL\u6570\u636e\u5e93\u6267\u884c\u5fc5\u8981\u7684\u67e5\u8be2\uff08\u6539\u52a8\uff09\u3002 \u901a\u8fc7MySQL\u53ef\u4ee5\u8fc5\u901f\u5730\u5b8c\u6210\u4ee5\u4e0a\u4efb\u52a1\uff0c\u4e3a\u4f60\u8282\u7701\u66f4\u591a\u65f6\u95f4\u3002<\/p>\n
\u4e0b\u9762\u8981\u4ecb\u7ecd\u7684\u5c31\u662f\u4e00\u4e9b\u7701\u65f6\u7701\u529b\u7684WordPress SQL\u67e5\u8be2\u65b9\u6cd5\u3002
\n <\/p>\n
\u4e8b\u5148\u5907\u4efd<\/strong><\/p>\n WordPress\u6570\u636e\u5e93\u91cc\u5b58\u50a8\u4e86\u4f60\u7cbe\u5fc3\u53d1\u8868\u7684\u6bcf\u4e00\u7bc7\u6587\u7ae0\uff0c\u6765\u81ea\u4f60\u7684\u8bfb\u8005\u7684\u6240\u6709\u8bc4\u8bba\uff0c\u4ee5\u53ca\u4f60\u5bf9\u81ea\u5df1\u7f51\u7ad9\u8fdb\u884c\u7684\u6240\u6709\u4e2a\u6027\u5316\u8bbe\u7f6e\u3002 \u56e0\u6b64\uff0c\u65e0\u8bba\u4f60\u5bf9\u81ea\u5df1\u6709\u591a\u81ea\u4fe1\uff0c\u90fd\u8bf7\u8bb0\u4f4f\u4e00\u5b9a\u8981\u4e8b\u5148\u5907\u4efdWordPress\u6570\u636e\u5e93\u3002 \u4f60\u53ef\u4ee5\u901a\u8fc7\u5907\u4efd\u63d2\u4ef6\u8fdb\u884c\u5907\u4efd\u3002 \u8fd9\u6bb5\u4ee3\u7801\u53ef\u4ee5\u4e3aWordPress\u6570\u636e\u5e93\u5185\u6240\u6709\u6587\u7ae0\u548c\u9875\u9762\u6dfb\u52a0\u4e00\u4e2a\u81ea\u5b9a\u4e49\u5b57\u6bb5\u3002 \u4f60\u9700\u8981\u505a\u7684\u5c31\u662f\u628a\u4ee3\u7801\u4e2d\u7684\u2018UniversalCutomField\u2018\u66ff\u6362\u6210\u4f60\u9700\u8981\u7684\u6587\u5b57\uff0c\u7136\u540e\u628a\u2018MyValue\u2018\u6539\u6210\u9700\u8981\u7684\u503c\u3002<\/p>\n [code]INSERT INTO wp_postmeta (post_id, meta_key, meta_value) SELECT ID AS post_id, ‘UniversalCustomField’ AS meta_key ‘MyValue AS meta_value FROM wp_posts WHERE ID NOT IN (SELECT post_id FROM wp_postmeta WHERE meta_key = ‘UniversalCustomField’);[\/code]<\/p>\n \u5982\u679c\u53ea\u9700\u8981\u4e3a\u6587\u7ae0\u6dfb\u52a0\u81ea\u5b9a\u4e49\u5b57\u6bb5\uff0c\u53ef\u4ee5\u4f7f\u7528\u4e0b\u9762\u8fd9\u6bb5\u4ee3\u7801\uff1a<\/p>\n [code]INSERT INTO wp_postmeta (post_id, meta_key, meta_value) SELECT ID AS post_id, ‘UniversalCustomField’ AS meta_key ‘MyValue AS meta_value FROM wp_posts WHERE ID NOT IN (SELECT post_id FROM wp_postmeta WHERE meta_key = ‘UniversalCustomField’) “ AND post_type = ‘post’;[\/code]<\/p>\n \u5982\u679c\u53ea\u9700\u8981\u4e3a\u9875\u9762\u6dfb\u52a0\u81ea\u5b9a\u4e49\u5b57\u6bb5\uff0c\u53ef\u4ee5\u4f7f\u7528\u4e0b\u9762\u8fd9\u6bb5\u4ee3\u7801\uff1a<\/p>\n [code]INSERT INTO wp_postmeta (post_id, meta_key, meta_value) SELECT ID AS post_id, ‘UniversalCustomField’ AS meta_key ‘MyValue AS meta_value FROM wp_posts WHERE ID NOT IN (SELECT post_id FROM wp_postmeta WHERE meta_key = ‘UniversalCustomField’) AND `post_type` = ‘page’;[\/code] \u5f53\u4f60\u5b89\u88c5\u6216\u5220\u9664\u63d2\u4ef6\u65f6\uff0c\u7cfb\u7edf\u901a\u8fc7\u6587\u7ae0meta\u6807\u7b7e\u5b58\u50a8\u6570\u636e\u3002 \u63d2\u4ef6\u88ab\u5220\u9664\u540e\uff0c\u6570\u636e\u4f9d\u7136\u4f1a\u5b58\u7559\u5728post_meta\u8868\u4e2d\uff0c\u5f53\u7136\u8fd9\u65f6\u4f60\u5df2\u7ecf\u4e0d\u518d\u9700\u8981\u8fd9\u4e9b\u6570\u636e\uff0c\u5b8c\u5168\u53ef\u4ee5\u5220\u9664\u4e4b\u3002 \u8bb0\u4f4f\u5728\u8fd0\u884c\u67e5\u8be2\u524d\u628a\u4ee3\u7801\u91cc\u7684\u2018YourMetaKey\u2018\u66ff\u6362\u6210\u4f60\u9700\u8981\u7684\u76f8\u5e94\u503c\u3002<\/p>\n [code]DELETE FROM \u00a0wp_postmeta WHERE meta_key = ‘YourMetaKey’;[\/code] \u5982\u679c\u4f60\u5728WordPress\u6570\u636e\u5e93\u91cc\u6267\u884c\u67e5\u8be2\u5220\u9664\u65e7\u6587\u7ae0\uff0c\u548c\u4e4b\u524d\u5220\u9664\u63d2\u4ef6\u65f6\u7684\u60c5\u51b5\u4e00\u6837\uff0c\u6587\u7ae0\u6240\u5c5e\u6807\u7b7e\u4f1a\u7559\u5728\u6570\u636e\u5e93\u91cc\uff0c\u5e76\u4e14\u8fd8\u4f1a\u51fa\u73b0\u5728\u6807\u7b7e\u5217\u8868\/\u6807\u7b7e\u4e91\u91cc\u3002 \u4e0b\u9762\u7684\u67e5\u8be2\u53ef\u4ee5\u5e2e\u4f60\u627e\u51fa\u65e0\u7528\u7684\u6807\u7b7e\u3002<\/p>\n [code]SELECT * From wp_terms wt INNER JOIN wp_term_taxonomy wtt ON wt.term_id=wtt.term_id WHERE wtt.taxonomy=’post_tag’ AND wtt.count=0;[\/code] \u6267\u884c\u4ee5\u4e0bSQL\u547d\u4ee4\uff1a<\/p>\n [code]DELETE FROM \u00a0wp_comments WHERE wp_comments.comment_approved = ‘spam’;[\/code] \u8fd9\u4e2aSQL\u67e5\u8be2\u4f1a\u5220\u9664\u4f60\u7684\u7f51\u7ad9\u4e0a\u6240\u6709\u672a\u5ba1\u6838\u8bc4\u8bba\uff0c\u4e0d\u5f71\u54cd\u5df2\u5ba1\u6838\u8bc4\u8bba\u3002<\/p>\n [code]DELETE FROM \u00a0wp_comments WHERE comment_approved = 0[\/code] \u6307\u5b9acomment_status\u7684\u503c\u4e3aopen\u3001closed\u6216registered_only\u3002 \u6b64\u5916\u8fd8\u9700\u8981\u8bbe\u7f6e\u65e5\u671f\uff08\u4fee\u6539\u4ee3\u7801\u4e2d\u76842010-01-01\uff09\uff1a<\/p>\n [code]UPDATE wp_posts \u00a0SET comment_status = ‘closed’ WHERE post_date \u00a0< ‘2010-01-01’ AND post_status = ‘publish’;[\/code] \u6307\u5b9acomment_status\u7684\u503c\u4e3aopen\u3001closed\u6216registered_only\u3002<\/p>\n \u5411\u6240\u6709\u7528\u6237\u6fc0\u6d3bpingbacks\/trackbacks\uff1a<\/p>\n [code]UPDATE wp_posts \u00a0SET ping_status = ‘open’;[\/code]<\/p>\n \u5411\u6240\u6709\u7528\u6237\u7981\u7528pingbacks\/trackbacks\uff1a<\/p>\n [code]UPDATE wp_posts \u00a0SET ping_status = ‘closed’;[\/code] \u6307\u5b9aping_status\u7684\u503c\u4e3aopen\u3001closed\u6216registered_only\u3002 \u6b64\u5916\u8fd8\u9700\u8981\u8bbe\u7f6e\u65e5\u671f\uff08\u4fee\u6539\u4ee3\u7801\u4e2d\u76842010-01-01\uff09\uff1a<\/p>\n [code]UPDATE wp_posts \u00a0SET ping_status = ‘closed’ WHERE post_date \u00a0< ‘2010-01-01’ AND post_status = ‘publish’;[\/code] \u5f53\u4f60\u53d1\u73b0\u5f88\u591a\u5783\u573e\u8bc4\u8bba\u90fd\u5e26\u6709\u76f8\u540c\u7684URL\u94fe\u63a5\uff0c\u53ef\u4ee5\u5229\u7528\u4e0b\u9762\u7684\u67e5\u8be2\u4e00\u6b21\u6027\u5220\u9664\u8fd9\u4e9b\u8bc4\u8bba\u3002%\u8868\u793a\u542b\u6709\u201c%\u201d\u7b26\u53f7\u5185\u5b57\u7b26\u4e32\u7684\u6240\u6709URL\u90fd\u5c06\u88ab\u5220\u9664\u3002<\/p>\n [code]DELETE from \u00a0wp_comments WHERE comment_author_url LIKE “%nastyspamurl%” \u00a0;[\/code] \u67e5\u627e\u201cX\u201d\u5929\u524d\u7684\u6240\u6709\u6587\u7ae0\uff08\u6ce8\u610f\u628aX\u66ff\u6362\u6210\u76f8\u5e94\u6570\u503c\uff09\uff1a<\/p>\n [code]SELECT * FROM `wp_posts` WHERE `post_type` = ‘post’AND DATEDIFF(NOW(), `post_date`) > X[\/code]<\/p>\n \u5220\u9664\u201cX\u201d\u5929\u524d\u7684\u6240\u6709\u6587\u7ae0\uff1a<\/p>\n [code]DELETE FROM `wp_posts` WHERE `post_type` = ‘post’AND DATEDIFF(NOW(), `post_date`) > X[\/code] \u5f53\u4f60\u51b3\u5b9a\u4e0d\u518d\u4f7f\u7528\u77ed\u4ee3\u7801\u65f6\uff0c\u5b83\u4eec\u4e0d\u4f1a\u81ea\u52a8\u6d88\u5931\u3002\u4f60\u53ef\u4ee5\u7528\u4e00\u4e2a\u7b80\u5355\u7684SQL\u67e5\u8be2\u547d\u4ee4\u5220\u9664\u6240\u6709\u4e0d\u9700\u8981\u7684\u77ed\u4ee3\u7801\u3002 \u628a\u201ctweet\u201d\u66ff\u6362\u6210\u76f8\u5e94\u77ed\u4ee3\u7801\u540d\u79f0\uff1a<\/p>\n [code]UPDATE wp_post \u00a0SET post_content = replace(post_content, ‘[tweet]’, ” ) \u00a0;[\/code] \u4f9d\u7136\u53ea\u8981\u901a\u8fc7PHPMyAdmin\u8fd0\u884c\u4e00\u4e2aSQL\u67e5\u8be2\u5c31\u53ef\u4ee5\u641e\u5b9a\uff1a<\/p>\n [code]UPDATE wp_posts \u00a0SET post_type = ‘page’ WHERE post_type = \u00a0‘post'[\/code]<\/p>\n \u5c06\u9875\u9762\u8f6c\u6362\u6210\u6587\u7ae0\uff1a<\/p>\n [code]UPDATE wp_posts \u00a0SET post_type = ‘post’ WHERE post_type = \u00a0‘page'[\/code] \u9996\u5148\u901a\u8fc7\u4e0b\u9762\u7684SQL\u547d\u4ee4\u68c0\u7d22\u4f5c\u8005\u7684ID\uff1a<\/p>\n [code]SELECT ID, \u00a0display_name FROM wp_users;[\/code]<\/p>\n \u6210\u529f\u83b7\u53d6\u8be5\u4f5c\u8005\u7684\u65b0\u65e7ID\u540e\uff0c\u63d2\u5165\u4ee5\u4e0b\u547d\u4ee4\uff0c\u8bb0\u4f4f\u7528\u65b0\u4f5c\u8005ID\u66ff\u6362NEW_AUTHOR_ID\uff0c\u65e7\u4f5c\u8005ID\u66ff\u6362OLD_AUTHOR_ID\u3002<\/p>\n [code]UPDATE wp_posts \u00a0SET post_author=NEW_AUTHOR_ID WHERE post_author=OLD_AUTHOR_ID;[\/code] \u6587\u7ae0\u4fee\u8ba2\u5386\u53f2\u4fdd\u5b58\u53ef\u4ee5\u5f88\u5b9e\u7528\uff0c\u4e5f\u53ef\u4ee5\u5f88\u8ba9\u4eba\u70e6\u607c\u3002 \u4f60\u53ef\u4ee5\u624b\u52a8\u5220\u9664\u4fee\u8ba2\u5386\u53f2\uff0c\u4e5f\u53ef\u4ee5\u5229\u7528SQL\u67e5\u8be2\u7ed9\u81ea\u5df1\u8282\u7701\u65f6\u95f4\u3002<\/p>\n [code]DELETE FROM \u00a0wp_posts WHERE post_type = “revision”;[\/code] \u6fc0\u6d3b\u67d0\u4e2a\u63d2\u4ef6\u540e\u53d1\u73b0\u65e0\u6cd5\u767b\u5f55WordPress\u7ba1\u7406\u9762\u677f\u4e86\uff0c\u8bd5\u8bd5\u4e0b\u9762\u7684\u67e5\u8be2\u547d\u4ee4\u5427\uff0c\u5b83\u4f1a\u7acb\u5373\u7981\u7528\u6240\u6709\u63d2\u4ef6\uff0c\u8ba9\u4f60\u91cd\u65b0\u767b\u5f55\u3002<\/p>\n [code]UPDATE wp_options \u00a0SET option_value = ‘a:0:{}’ WHERE option_name \u00a0= ‘active_plugins’;[\/code] \u628aWordPress\u535a\u5ba2\uff08\u6a21\u677f\u6587\u4ef6\u3001\u4e0a\u4f20\u5185\u5bb9&\u6570\u636e\u5e93\uff09\u4ece\u4e00\u53f0\u670d\u52a1\u5668\u79fb\u5230\u53e6\u4e00\u53f0\u670d\u52a1\u5668\u540e\uff0c\u63a5\u4e0b\u6765\u4f60\u9700\u8981\u544a\u8bc9WordPress\u4f60\u7684\u65b0\u535a\u5ba2\u5730\u5740\u3002<\/p>\n \u4f7f\u7528\u4ee5\u4e0b\u547d\u4ee4\u65f6\uff0c\u6ce8\u610f\u5c06http:\/\/www.old-site.com\u6362\u6210\u4f60\u7684\u539fURL\uff0chttp:\/\/www.new-site.com\u6362\u6210\u65b0URL\u5730\u5740\u3002<\/p>\n \u9996\u5148\uff1a<\/p>\n [code]UPDATE wp_options \u7136\u540e\u5229\u7528\u4e0b\u9762\u7684\u547d\u4ee4\u66f4\u6539wp_posts\u91cc\u7684URL\uff1a<\/p>\n [code]UPDATE wp_posts \u00a0SET guid = replace(guid, ‘http:\/\/www.old-site.com’,’http:\/\/www.new-site.com);[\/code]<\/p>\n \u6700\u540e\uff0c\u641c\u7d22\u6587\u7ae0\u5185\u5bb9\u4ee5\u786e\u4fdd\u65b0URL\u94fe\u63a5\u4e0e\u539f\u94fe\u63a5\u6ca1\u6709\u5f04\u6df7\uff1a<\/p>\n [code]UPDATE wp_posts \u628a\u5176\u4e2d\u7684YourNewUsername\u66ff\u6362\u6210\u65b0\u7528\u6237\u540d\u3002<\/p>\n [code]UPDATE wp_users \u00a0SET user_login = ‘YourNewUsername’ WHERE user_login \u00a0= ‘Admin’;[\/code] \u5982\u679c\u4f60\u662f\u4f60\u7684WordPress\u7f51\u7ad9\u4e0a\u7684\u552f\u4e00\u4f5c\u8005\uff0c\u5e76\u4e14\u4f60\u6ca1\u6709\u4fee\u6539\u9ed8\u8ba4\u7528\u6237\u540d\uff0c \u8fd9\u65f6\u4f60\u53ef\u4ee5\u7528\u4e0b\u9762\u7684SQL\u67e5\u8be2\u6765\u91cd\u7f6e\u5bc6\u7801\uff08\u628a\u5176\u4e2d\u7684PASSWORD\u6362\u6210\u65b0\u5bc6\u7801\uff09\uff1a<\/p>\n [code]UPDATE `wordpress`.`wp_users` \u00a0SET `user_pass` = MD5(‘PASSWORD’) WHERE `wp_users`.`user_login` \u00a0=`admin` LIMIT 1;[\/code] OriginalText\u6362\u6210\u88ab\u66ff\u6362\u5185\u5bb9\uff0cReplacedText\u6362\u6210\u76ee\u6807\u5185\u5bb9\uff1a<\/p>\n [code]UPDATE wp_posts SET `post_content` = REPLACE (`post_content`, ‘OriginalText’,’ReplacedText’);[\/code] \u4e0b\u9762\u7684SQL\u547d\u4ee4\u53ef\u4ee5\u5e2e\u4f60\u4fee\u6539\u56fe\u7247\u8def\u5f84\uff1a<\/p>\n [code]UPDATE wp_posts SET post_content = REPLACE (post_content, ‘src=\u201dhttp:\/\/www.myoldurl.com’, ‘src=\u201dhttp:\/\/www.mynewurl.com’);[\/code]<\/p>\n \u8f6c\u8f7d\uff1awordpress\u5566\uff01<\/p>\n","protected":false},"excerpt":{"rendered":" WordPress\u5c06\u5176\u6240\u6709\u4fe1\u606f\u7247\u6bb5\uff08\u5305\u62ec\u6587\u7ae0\u3001\u9875\u9762\u3001\u8bc4\u8bba\u3001\u535a\u5ba2\u94fe\u63a5\u3001\u63d2\u4ef6\u8bbe\u7f6e\u7b49\uff09\u5b58\u50a8\u5728MySQL\u6570\u636e\u5e93\u4e2d\u3002 \u867d […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"close","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,11],"tags":[],"class_list":["post-446","post","type-post","status-publish","format-standard","hentry","category-wordpress","category-11"],"_links":{"self":[{"href":"https:\/\/sdeno.com\/index.php?rest_route=\/wp\/v2\/posts\/446","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sdeno.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sdeno.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sdeno.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sdeno.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=446"}],"version-history":[{"count":0,"href":"https:\/\/sdeno.com\/index.php?rest_route=\/wp\/v2\/posts\/446\/revisions"}],"wp:attachment":[{"href":"https:\/\/sdeno.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=446"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdeno.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=446"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdeno.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=446"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n
\n\u4e3a\u6240\u6709\u6587\u7ae0\u548c\u9875\u9762\u6dfb\u52a0\u81ea\u5b9a\u4e49\u5b57\u6bb5<\/strong><\/p>\n
\n
\n\u5220\u9664\u6587\u7ae0meta\u6570\u636e<\/strong><\/p>\n
\n
\n\u67e5\u627e\u65e0\u7528\u6807\u7b7e<\/strong><\/p>\n
\n
\n\u6279\u91cf\u5220\u9664\u5783\u573e\u8bc4\u8bba<\/strong><\/p>\n
\n
\n\u6279\u91cf\u5220\u9664\u6240\u6709\u672a\u5ba1\u6838\u8bc4\u8bba<\/strong><\/p>\n
\n
\n\u7981\u6b62\u8bc4\u8bba\u8f83\u65e9\u6587\u7ae0<\/strong><\/p>\n
\n
\n\u505c\u7528\/\u6fc0\u6d3btrackback\u4e0epingback<\/strong><\/p>\n
\n
\n\u6fc0\u6d3b\/\u505c\u7528\u67d0\u4e00\u65e5\u671f\u524d\u7684Pingbacks & Trackbacks<\/strong><\/p>\n
\n
\n\u5220\u9664\u7279\u5b9aURL\u7684\u8bc4\u8bba<\/strong><\/p>\n
\n
\n\u8bc6\u522b\u5e76\u5220\u9664\u201cX\u201d\u5929\u524d\u7684\u6587\u7ae0<\/strong><\/p>\n
\n
\n\u5220\u9664\u4e0d\u9700\u8981\u7684\u77ed\u4ee3\u7801<\/strong><\/p>\n
\n
\n\u5c06\u6587\u7ae0\u8f6c\u4e3a\u9875\u9762<\/strong><\/p>\n
\n
\n\u66f4\u6539\u6240\u6709\u6587\u7ae0\u4e0a\u7684\u4f5c\u8005\u5c5e\u6027<\/strong><\/p>\n
\n
\n\u6279\u91cf\u5220\u9664\u6587\u7ae0\u4fee\u8ba2\u5386\u53f2<\/strong><\/p>\n
\n
\n\u505c\u7528\/\u6fc0\u6d3b\u6240\u6709WordPress\u63d2\u4ef6<\/strong><\/p>\n
\n
\n\u66f4\u6539WordPress\u7f51\u7ad9\u7684\u76ee\u6807URL<\/strong><\/p>\n
\nSET option_value = replace(option_value, ‘http:\/\/www.old-site.com’, ‘http:\/\/www.new-site.com’)
\nWHERE option_name = ‘home’ OR option_name = ‘siteurl’;[\/code]<\/p>\n
\nSET post_content = replace(post_content, ‘ http:\/\/www.ancien-site.com ‘, ‘ http:\/\/www.nouveau-site.com ‘);[\/code]
\n
\n\u66f4\u6539\u9ed8\u8ba4\u7528\u6237\u540dAdmin<\/strong><\/p>\n
\n
\n\u624b\u52a8\u91cd\u7f6eWordPress\u5bc6\u7801<\/strong><\/p>\n
\n
\n\u641c\u7d22\u5e76\u66ff\u6362\u6587\u7ae0\u5185\u5bb9<\/strong><\/p>\n
\n
\n\u66f4\u6539\u56fe\u7247URL<\/strong><\/p>\n