Skip to content

Instantly share code, notes, and snippets.

@TheHiddenHaku
Last active May 2, 2019 09:06
Show Gist options
  • Save TheHiddenHaku/94c60c6741af690b0783 to your computer and use it in GitHub Desktop.
Save TheHiddenHaku/94c60c6741af690b0783 to your computer and use it in GitHub Desktop.
Wordpress change domain queries
UPDATE
wp_options
SET
option_value = replace(option_value, 'http://www.old-domain.com', 'http://www.new-domain.com')
WHERE
option_name = 'home' OR
option_name = 'siteurl';
#option_name = 'wsl_settings_redirect_url';
UPDATE
wp_posts
SET
guid = replace(guid, 'http://www.old-domain.com', 'http://www.new-domain.com');
UPDATE
wp_posts
SET
post_content = replace(post_content, 'http://www.old-domain.com', 'http://www.new-domain.com');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment