Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- USE table_name;
- SET @old_url = 'domain.com';
- SET @new_url = 'new-domain.com';
- UPDATE wp_options SET option_value = replace(option_value, @old_url, @new_url) WHERE option_name = 'home' OR option_name = 'siteurl';
- UPDATE wp_posts SET post_content = replace(post_content, @old_url, @new_url);
- UPDATE wp_postmeta SET meta_value = replace(meta_value, @old_url, @new_url);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement