WordPress website migration

In order to migrate the wordpress site from one domain to another, you have to change the old urls also. Sometimes you changed the home_url and the site_url. But at that time there must be cases that all the urls are not updated properly, hence the site may get broken links. 

To avoid such conditions you can simply execute the below queries in your database.

1. UPDATE wp_options SET option_value = replace(option_value, ‘http://www.oldurl’, ‘http://www.newurl’) WHERE option_name = ‘home’ OR option_name = ‘siteurl’;
2. UPDATE wp_posts SET guid = replace(guid, ‘http://www.oldurl’,’http://www.newurl’);
3. UPDATE wp_posts SET post_content = replace(post_content, ‘http://www.oldurl’, ‘http://www.newurl’);
4. UPDATE wp_postmeta SET meta_value = replace(meta_value,’http://www.oldurl’,’http://www.newurl’);