WordPress更换域名的办法

2010.04.20 No Comments

在phpmyadmin执行下面三条SQL语句

www.shangpan.com为原域名,blog.shangpan.com为新域名。

修改option_value里的站点url和主页地址:

UPDATE wp_options SET option_value = replace(option_value, 'http://shangpan.com', 'http://blog.shangpan.com') WHERE option_name = 'home' OR option_name = 'siteurl';

更正文章中内部链接及附件的地址:

UPDATE wp_posts SET post_content = replace(post_content, 'http://shangpan.com', 'http://blog.shangpan.com');

更正wordpress文章默认的永久链接:

UPDATE wp_posts SET guid = replace(guid, 'http://shangpan.com', 'http://blog.shangpan.com');

Related Posts:
Leave a Reply
icon_wink.gif icon_neutral.gif icon_mad.gif icon_twisted.gif icon_smile.gif icon_eek.gif icon_sad.gif icon_rolleyes.gif icon_razz.gif icon_redface.gif icon_surprised.gif icon_mrgreen.gif icon_lol.gif icon_idea.gif icon_biggrin.gif icon_evil.gif icon_cry.gif icon_cool.gif icon_arrow.gif icon_confused.gif icon_question.gif icon_exclaim.gif