Skip to content

Instantly share code, notes, and snippets.

@oneluiz

oneluiz/url.sql

Created August 23, 2018 15:31
Show Gist options
  • Save oneluiz/f934154ec864d2972b5992d4fe59e5e3 to your computer and use it in GitHub Desktop.
Save oneluiz/f934154ec864d2972b5992d4fe59e5e3 to your computer and use it in GitHub Desktop.
Download ZIP
Cambiar URL WordPress
Raw
url.sql
UPDATE `wp_posts` SET guid = REPLACE(guid, 'http://www.URL-VIEJA.com','http://www.URL-NUEVA.com');
UPDATE `wp_posts` SET post_content = REPLACE(post_content, 'http://www.URL-VIEJA.com','http://www.URL-NUEVA.com');
UPDATE `wp_options` SET option_value = REPLACE(option_value, 'http://www.URL-VIEJA.com','http://www.URL-NUEVA.com') WHERE option_name = 'home' OR option_name = 'siteurl';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment