Changing your WordPress domain name URL

When you have to migrate a site from one URL to a new domain name, the following SQL commands will help you out.

These can be run from the CLI or PHPMyadmin as a standard SQL statement.

UPDATE wp_options SET option_value = replace(option_value, ‘’, ‘’) WHERE option_name = ‘home’ OR option_name = ‘siteurl’;

UPDATE wp_posts SET guid = replace(guid, ‘’, ‘’);
UPDATE wp_posts SET post_content = replace(post_content, ‘’, ‘’);
UPDATE wp_postmeta SET meta_value = replace(meta_value, ‘’, ‘’);
As a side note, you will probably have to change every instance of your website home directory too if this has changed. eg, /home/oldsite would become /home/newsite. You can modify the above commands to perform this for you.
This entry was posted in Computer and tagged , . Bookmark the permalink.