Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SET @oldsite = 'URL', @newsite = 'URL';
- UPDATE wp_options SET option_value = replace(option_value, @oldsite, @newsite) WHERE option_name = 'home' OR option_name = 'siteurl';
- UPDATE wp_posts SET guid = replace(guid, @oldsite,@newsite);
- UPDATE wp_posts SET post_content = replace(post_content, @oldsite, @newsite);
- UPDATE wp_postmeta SET meta_value = replace(meta_value, @oldsite,@newsite);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement