wordpress 更换域名-数据迁移

wordpress 更换域名-数据迁移

老域名：limone-swim.com
新域名：dev.limone.imgozi.cn

数据库操作

如果数据库有设置前缀，将 wp 改成你设置的前缀。

UPDATE wp_posts SET post_content
= replace( post_content, ‘limone-swim.com’,‘dev.limone.imgozi.cn’);

UPDATE wp_posts SET guid
= replace( guid, ‘limone-swim.com’,‘dev.limone.imgozi.cn’);

UPDATE wp_postmeta SET meta_value
= replace(meta_value, ‘limone-swim.com’,‘dev.limone.imgozi.cn’);

UPDATE wp_users SET user_url
= replace(user_url, ‘limone-swim.com’,‘dev.limone.imgozi.cn’);

UPDATE wp_options SET option_value
= replace( option_value, ‘limone-swim.com’, ‘dev.limone.imgozi.cn’);