Manually Modifying WordPress’s URL via SQL

, ,

Sometimes it is easiest to modify the URL globally through SQL.  Here are the main commands you are going to want to run to modify the URL's throughout the database.

UPDATE wp_options SET option_value = replace(option_value, 'http://www.oldurl', 'http://www.newurl') WHERE option_name = 'home' OR option_name = 'siteurl';

UPDATE wp_posts SET guid = replace(guid, 'http://www.oldurl','http://www.newurl');

UPDATE wp_posts SET post_content = replace(post_content, 'http://www.oldurl', 'http://www.newurl');

UPDATE wp_postmeta SET meta_value = replace(meta_value,'http://www.oldurl','http://www.newurl');

 

Skills

Posted on

October 28, 2015

Submit a Comment

Your email address will not be published.