Skip to content

Instantly share code, notes, and snippets.

@pablocampina
Last active August 29, 2015 14:14
Show Gist options
  • Save pablocampina/10a47fca6a1a8e10cc32 to your computer and use it in GitHub Desktop.
Save pablocampina/10a47fca6a1a8e10cc32 to your computer and use it in GitHub Desktop.
Change all URL into wordpress
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