wordpress更换域名空间
发布时间:2019-02-25作者:豆子点击:112
UPDATE wp_options SET option_value = replace(option_value,
'www.mydomain.com'
,
'www.newdomain.com'
) ;
UPDATE wp_posts SET post_content = replace(post_content,
'www.mydomain.com'
,
'www.newdomain.com'
) ;
UPDATE wp_posts SET guid = replace(guid,
'www.mydomain.com'
,
'www.newdomain.com'
) ;
UPDATE wp_comments SET comment_content = replace(comment_content,
'www.mydomain.com'
,
'www.newdomain.com'
) ;
UPDATE wp_comments SET comment_author_url = replace(comment_author_url,
'www.mydomain.com'
,
'www.newdomain.com'
) ;
第四步:从旧网站后台导出主题,再导入到新网站后台。