修改wordpress项目域名

    技术2022-07-14  80

    进入到wordpress数据库按照新老域名将下面的四个sql写好,然后执行, 完美解决wordpress项目替换域名

    UPDATE wp_options SET option_value = replace(option_value, ‘www.old.com’,‘www.new.com’) ; UPDATE wp_posts SET post_content = replace(post_content, ‘www.old.com’,‘www.new.com’) ; UPDATE wp_comments SET comment_content = replace(comment_content, ‘www.old.com’, ‘www.new.com’) ; UPDATE wp_comments SET comment_author_url = replace(comment_author_url, ‘www.old.com’, ‘www.new.com’) ;

    Processed: 0.013, SQL: 9