Skip to content

Instantly share code, notes, and snippets.

@shanaver

shanaver/change_domain.sql

Last active December 27, 2015 04:48
Show Gist options
  • Save shanaver/7269133 to your computer and use it in GitHub Desktop.
Save shanaver/7269133 to your computer and use it in GitHub Desktop.
Download ZIP
Wordpress domain change entire database for local testing
Raw
change_domain.sql
update wp_posts set guid = replace(guid, "livesite.org", "testsite.local");
update wp_options set option_value = replace(option_value, "livesite.org", "testsite.local");
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment