Update WP siteurl

-- Check siteurl
SELECT option_value FROM wp_options WHERE option_name = 'siteurl'


-- Update URL_move_from and URL_move_to inside single quotes
UPDATE wp_options SET option_value = replace( option_value, 'URL_move_from', 'URL_move_to' ) WHERE option_name = 'home' OR option_name = 'siteurl';
UPDATE wp_posts SET guid = replace(guid, 'URL_move_from','URL_move_to');
UPDATE wp_posts SET post_content = replace(post_content, 'URL_move_from','URL_move_to');

 

Update db ¬†prefix, this example is for default “wp_”

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.