Skip to content

Instantly share code, notes, and snippets.

@fernandiez

fernandiez/update-domain.php

Created July 15, 2015 13:43
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save fernandiez/2c62b85c05855398af13 to your computer and use it in GitHub Desktop.
Save fernandiez/2c62b85c05855398af13 to your computer and use it in GitHub Desktop.
Download ZIP
SQL update to change domain name in WordPress database
Raw
update-domain.php
// SQL update to change domain name in WordPress database
// wp_options
UPDATE wp_options SET option_value = REPLACE (option_value, 'demo.domain.com', 'www.domain.com');
// wp_postmeta
UPDATE wp_postmeta SET meta_value = REPLACE (meta_value, 'demo.domain.com', 'www.domain.com');
// wp_options
UPDATE wp_posts SET post_content = REPLACE (post_content, 'demo.domain.com', 'www.domain.com');
// wp_posts
UPDATE wp_posts SET guid = REPLACE (guid, 'demo.domain.com', 'www.domain.com');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment