wordpress域名变更后数据库修改

当wordpress项目的域名需要变更时
只需要修改以下四张表即可,以下以mysql为例

UPDATE wp_posts SET post_content = replace(post_content, '旧域名', '新域名');

UPDATE wp_options SET option_value = replace(option_value, '旧域名', '新域名');

UPDATE wp_posts SET guid = replace(guid, '旧域名', '新域名');

UPDATE wp_posts SET pinged = replace(pinged, '旧域名', '新域名');