Skip to content

Instantly share code, notes, and snippets.

@douglascabral

douglascabral/change-url-wp.sql

Created September 16, 2016 20:29
Show Gist options
  • Save douglascabral/c9a76cc3e6bb3692d196fc33332717ce to your computer and use it in GitHub Desktop.
Save douglascabral/c9a76cc3e6bb3692d196fc33332717ce to your computer and use it in GitHub Desktop.
Download ZIP
Change the URL WordPress
Raw
change-url-wp.sql
UPDATE wp_commentmeta SET meta_value = REPLACE(meta_value, 'http://site.com.br', 'http://localhost/');
UPDATE wp_options SET option_value = REPLACE(option_value, 'http://site.com.br', 'http://localhost/');
UPDATE wp_posts SET guid = REPLACE(guid, 'http://site.com.br', 'http://localhost/');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment