Skip to content

Instantly share code, notes, and snippets.

@seblavoie

seblavoie/update-url.sql

Created February 8, 2013 18:36
Show Gist options
  • Save seblavoie/4740996 to your computer and use it in GitHub Desktop.
Save seblavoie/4740996 to your computer and use it in GitHub Desktop.
Download ZIP
Update wordpress URL
Raw
update-url.sql
UPDATE wp_posts SET wp_posts.guid=REPLACE(wp_posts.guid,
'olddomain.com',
'newdomain.com'
);
UPDATE wp_options SET wp_options.option_value='http://newdomain.com' WHERE wp_options.option_name='siteurl' OR wp_options.option_name='home';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment