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’);