诗人博客WP数据库域名替换示例

UPDATE wp_options SET option_value = replace(option_value,'http://www.i-

black.cn','https://www.bluenoob.com') WHERE option_name = 'home' OR option_name = 'siteurl';

UPDATE wp_posts SET post_content = replace(post_content,'http://www.i-

black.cn','https://www.bluenoob.com');

UPDATE wp_posts SET guid = replace(guid,'http://www.i-black.cn','https://www.bluenoob.com');

domain格式 http://spoint.babyshoot.cn 最后不要带"/"

=============================================

换域名了，忘了做301，诗人百度了下替换数据库中域名的方法，贴出来共享一下