用SQL命令批量替换WordPress旧域名,避免插件出错
迁移站点后,数据库里还有旧域名链接。用Better Search Replace插件,但大站点会超时。
改用SQL命令直接操作(先备份数据库):
UPDATE wp_posts SET post_content = REPLACE(post_content, 'old.com', 'new.com');
UPDATE wp_options SET option_value = REPLACE(option_value, 'old.com', 'new.com') WHERE option_name ...