Skip to content

Instantly share code, notes, and snippets.

@frankyston
Forked from pablocampina/wp_local_to_on
Last active August 29, 2015 14:20
Show Gist options
  • Save frankyston/df128a93e814ae950070 to your computer and use it in GitHub Desktop.
Save frankyston/df128a93e814ae950070 to your computer and use it in GitHub Desktop.
UPDATE wp_options
SET option_value = REPLACE(option_value, 'http://localhost', 'http://www.seudomino.com')
WHERE option_name = 'home'
OR option_name = 'siteurl';
UPDATE wp_posts
SET guid = REPLACE (guid, 'http://localhost', 'http://www.seudomino.com');
UPDATE wp_posts
SET post_content = REPLACE (post_content, 'http://localhost', 'http://www.seudomino.com');
UPDATE wp_posts
SET guid = REPLACE (guid, 'http://localhost', 'http://www.seudomino.com') WHERE post_type = 'attachment';
UPDATE wp_postmeta
SET meta_value = REPLACE (meta_value, 'http://localhost', 'http://www.seudomino.com');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment