Skip to content

Instantly share code, notes, and snippets.

@siriokun

siriokun/query.sql

Created January 8, 2019 10:36
Show Gist options
  • Save siriokun/7bbca370bf205fc342eb14331e3cba03 to your computer and use it in GitHub Desktop.
Save siriokun/7bbca370bf205fc342eb14331e3cba03 to your computer and use it in GitHub Desktop.
Download ZIP
Change WordPress links from live site to localhost
Raw
query.sql
// Change home_url to localhost
update wp_options set option_value =
replace(option_value,'http://yourlivesite.tld','http://localhost/wp');
// Change links in content
update wp_posts set post_content =
replace(post_content,'http://yourlivesite.tld','http://localhost/wp');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment