WordPress站点域名更换

进入phpMyadmin选择对应数据库执行SQL语句

/* 设置新旧域名 */
SET @oldurl := "http://www.old.com/";
SET @newurl := "http://www.new.com/";
/* 替换wordprss地址和站点地址 */
UPDATE wp_options SET option_value = replace(option_value, @oldurl, @newurl) WHERE option_name = 'home' OR option_name = 'siteurl';
/* 替换所有 content 中url */
UPDATE wp_posts SET post_content = replace(post_content, @oldurl, @newurl);
UPDATE wp_posts SET guid = REPLACE (guid, @oldurl, @newurl);
/* 替换wordpress链接url */
UPDATE wp_links SET link_url = replace(link_url, @oldurl, @newurl);
/* 替换所有图片url */
UPDATE wp_links SET link_image = replace(link_image, @oldurl, @newurl);
/* 替换所有用户的url */
UPDATE wp_usermeta SET meta_value = replace(meta_value, @oldurl, @newurl);
/* 替换所有评论作者的url */
UPDATE wp_comments SET comment_author_url = REPLACE(comment_author_url, @oldurl, @newurl);