Skip to content

Instantly share code, notes, and snippets.

@victor-falcon
victor-falcon / wordpress-new-domain.sql
Last active December 14, 2015 14:08
Query to change wordpress domain
SET @newdomain:='http://nuevadominio.com';
SET @olddomain:='http://localhost:8888/old';
UPDATE wp_options
SET option_value = @newdomain
WHERE option_name IN ('siteurl','home');
UPDATE wp_posts
SET post_content = replace(post_content,@olddomain,@newdomain);
UPDATE wp_posts
SET guid = replace(guid,@olddomain,@newdomain);