Skip to content

Instantly share code, notes, and snippets.

@ben-barbier

ben-barbier/change-wordpress-domain.sql

Last active January 18, 2017 08:20
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 ben-barbier/69c35380af8475da0a9c617f73ba0694 to your computer and use it in GitHub Desktop.
Save ben-barbier/69c35380af8475da0a9c617f73ba0694 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
change-wordpress-domain.sql
UPDATE wp_options SET option_value = REPLACE(option_value, 'http://monsite.preprod.fr', 'http://www.prod.fr') WHERE option_value LIKE '%http://monsite.preprod.fr%';
UPDATE wp_posts SET post_content = REPLACE(post_content, 'http://monsite.preprod.fr', 'http://www.prod.fr') WHERE post_content LIKE '%http://monsite.preprod.fr%';
UPDATE wp_posts SET guid = REPLACE(guid, 'http://monsite.preprod.fr', 'http://www.prod.fr') WHERE guid LIKE '%http://monsite.preprod.fr%';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment