Skip to content

Instantly share code, notes, and snippets.

@gabrielmansour

gabrielmansour/wp_migrate.sql

Created December 20, 2010 18:47
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 gabrielmansour/748803 to your computer and use it in GitHub Desktop.
Save gabrielmansour/748803 to your computer and use it in GitHub Desktop.
Download ZIP
Wordpress Domain Migration script
Raw
wp_migrate.sql
SET @old='http://old.example.com', @new='http://new.example.com';
UPDATE wp_options SET option_value = replace(option_value, @old, @new) WHERE option_name = 'home' OR option_name = 'siteurl';
UPDATE wp_posts SET guid = replace(guid, @old, @new);
UPDATE wp_posts SET post_content = replace(post_content, @old, @new);
UPDATE wp_posts SET post_excerpt = replace(post_excerpt, @old, @new);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment