Skip to content

Instantly share code, notes, and snippets.

@mikemanger

mikemanger/update-wp-multisite-domain.sql

Created March 10, 2014 16:23
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 mikemanger/9468332 to your computer and use it in GitHub Desktop.
Save mikemanger/9468332 to your computer and use it in GitHub Desktop.
Download ZIP
Run this for each wp_*_options table.
Raw
update-wp-multisite-domain.sql
UPDATE wp_x_options
SET option_value = REPLACE(option_value, 'old.domain.com', 'new.domain.com')
WHERE option_name = 'siteurl'
OR option_name = 'home'
OR option_name = 'fileupload_url';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment