一、进入数据库
以宝塔面板为例,在“对应数据库-管理”,用phpMyAdmin进入数据库。
二、执行SQL语句
在phpMyAdmin数据库管理面板找到SQL,然后执行下面的SQL语句
<span class="hljs-keyword"><span class="pln">UPDATE</span></span><span class="pln"> wp_options </span><span class="hljs-keyword"><span class="pln">SET</span></span><span class="pln"> option_value </span><span class="pun">=</span> <span class="hljs-keyword"><span class="pln">replace</span></span><span class="pun">(</span><span class="pln">option_value</span><span class="pun">,</span><span class="hljs-string"><span class="str">'旧域名'</span></span><span class="pun">,</span><span class="hljs-string"><span class="str">'ixxx.com'</span></span><span class="pun">);</span><span class="hljs-keyword"><span class="pln">UPDATE</span></span><span class="pln"> wp_posts </span><span class="hljs-keyword"><span class="pln">SET</span></span><span class="pln"> post_content </span><span class="pun">=</span> <span class="hljs-keyword"><span class="pln">replace</span></span><span class="pun">(</span><span class="pln">post_content</span><span class="pun">,</span><span class="hljs-string"><span class="str">'旧域名'</span></span><span class="pun">,</span><span class="hljs-string"><span class="str">'xxx0.com'</span></span><span class="pun">);</span><span class="hljs-keyword"><span class="pln">UPDATE</span></span><span class="pln"> wp_posts </span><span class="hljs-keyword"><span class="pln">SET</span></span><span class="pln"> post_excerpt</span><span class="pun">=</span> <span class="hljs-keyword"><span class="pln">replace</span></span><span class="pun">(</span><span class="pln">post_excerpt</span><span class="pun">,</span><span class="hljs-string"><span class="str">'旧域名'</span></span><span class="pun">,</span><span class="hljs-string"><span class="str">'xxx.com'</span></span><span class="pun">);</span><span class="hljs-keyword"><span class="pln">UPDATE</span></span><span class="pln"> wp_comments </span><span class="hljs-keyword"><span class="pln">SET</span></span><span class="pln"> comment_author_url </span><span class="pun">=</span> <span class="hljs-keyword"><span class="pln">replace</span></span><span class="pun">(</span><span class="pln">comment_author_url</span><span class="pun">,</span><span class="hljs-string"><span class="str">'旧域名'</span></span><span class="pun">,</span><span class="hljs-string"><span class="str">'xxxcom'</span></span><span class="pun">);</span><span class="hljs-keyword"><span class="pln">UPDATE</span></span><span class="pln"> wp_postmeta </span><span class="hljs-keyword"><span class="pln">SET</span></span><span class="pln"> meta_value </span><span class="pun">=</span> <span class="hljs-keyword"><span class="pln">replace</span></span><span class="pun">(</span><span class="pln">meta_value</span><span class="pun">,</span><span class="hljs-string"><span class="str">'旧域名'</span></span><span class="pun">,</span><span class="hljs-string"><span class="str">'ixxx.com'</span></span><span class="pun">);</span><span class="hljs-keyword"><span class="pln">UPDATE</span></span><span class="pln"> wp_options </span><span class="hljs-keyword"><span class="pln">SET</span></span><span class="pln"> option_value </span><span class="pun">=</span> <span class="hljs-keyword"><span class="pln">replace</span></span><span class="pun">(</span><span class="pln">option_value</span><span class="pun">,</span><span class="hljs-string"><span class="str">'旧域名'</span></span><span class="pun">,</span><span class="hljs-string"><span class="str">'ixxx.com'</span></span><span class="pun">);</span>
<span class="hljs-keyword"><span class="pln">UPDATE</span></span><span class="pln"> wp_posts </span><span class="hljs-keyword"><span class="pln">SET</span></span><span class="pln"> post_content </span><span class="pun">=</span> <span class="hljs-keyword"><span class="pln">replace</span></span><span class="pun">(</span><span class="pln">post_content</span><span class="pun">,</span><span class="hljs-string"><span class="str">'旧域名'</span></span><span class="pun">,</span><span class="hljs-string"><span class="str">'xxx0.com'</span></span><span class="pun">);</span>
<span class="hljs-keyword"><span class="pln">UPDATE</span></span><span class="pln"> wp_posts </span><span class="hljs-keyword"><span class="pln">SET</span></span><span class="pln"> post_excerpt</span><span class="pun">=</span> <span class="hljs-keyword"><span class="pln">replace</span></span><span class="pun">(</span><span class="pln">post_excerpt</span><span class="pun">,</span><span class="hljs-string"><span class="str">'旧域名'</span></span><span class="pun">,</span><span class="hljs-string"><span class="str">'xxx.com'</span></span><span class="pun">);</span>
<span class="hljs-keyword"><span class="pln">UPDATE</span></span><span class="pln"> wp_comments </span><span class="hljs-keyword"><span class="pln">SET</span></span><span class="pln"> comment_author_url </span><span class="pun">=</span> <span class="hljs-keyword"><span class="pln">replace</span></span><span class="pun">(</span><span class="pln">comment_author_url</span><span class="pun">,</span><span class="hljs-string"><span class="str">'旧域名'</span></span><span class="pun">,</span><span class="hljs-string"><span class="str">'xxxcom'</span></span><span class="pun">);</span>
<span class="hljs-keyword"><span class="pln">UPDATE</span></span><span class="pln"> wp_postmeta </span><span class="hljs-keyword"><span class="pln">SET</span></span><span class="pln"> meta_value </span><span class="pun">=</span> <span class="hljs-keyword"><span class="pln">replace</span></span><span class="pun">(</span><span class="pln">meta_value</span><span class="pun">,</span><span class="hljs-string"><span class="str">'旧域名'</span></span><span class="pun">,</span><span class="hljs-string"><span class="str">'ixxx.com'</span></span><span class="pun">);</span>
UPDATE wp_options SET option_value = replace(option_value,'旧域名','ixxx.com');
UPDATE wp_posts SET post_content = replace(post_content,'旧域名','xxx0.com');
UPDATE wp_posts SET post_excerpt= replace(post_excerpt,'旧域名','xxx.com');
UPDATE wp_comments SET comment_author_url = replace(comment_author_url,'旧域名','xxxcom');
UPDATE wp_postmeta SET meta_value = replace(meta_value,'旧域名','ixxx.com');
把语句中的“旧域名”替换成之前的域名,“idxxxx.com”替换为更换后的域名。
确认无误后点击右下角的执行按钮。
总结
这种方法步骤少,而且操作也是非常简单。执行5段SQL语句即可将数据库中配置、文章内容、文章摘要、评论者URL地址、自定义字段中的旧域名全部更换为新域名了。
Have faith in your dreams and someday your rainbow will come smiling through.
请对梦想充满信心,总有一天属于你的彩虹会在天空微笑
© 版权声明
文章版权归作者所有,未经允许请勿转载。
THE END
暂无评论内容