So you are moving your WordPress site to a new server. Be sure to change and update your site’s URLs in the database. Here is how you can do that:
 

First, make sure you have a new database selected. Now, run SQL update and replacement commands on the tables, particularly, wp_options, wp_posts, and wp_postmeta.
 

Use the below codes in order to swap in your old URLs with the new ones.
 
Note:

  1. Avoid trailing slashes
  2. If necessary, change the table prefix values wherever applicable, i.e., wp_xxx

All right, let’s see the codes:
 
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’);
 
Did the above codes worked for you? Need further assistance?
 

If you have any sort of problem with your WordPress site, kindly contact our WordPress developers at http://www.conceptinfoway.net/contact-us/.
 

Concept Infoway is a leading WordPress development company in India from where you can hire an expert WordPress developer or a team of WordPress programmers at affordable rates. Hire our WordPress resources for:
 

  • WordPress Website Development
  • WordPress CMS Development
  • WordPress Ecommerce Development (WooCommerce Development)
  • WordPress Blog Development
  • WordPress Plugin Development & Customization
  • WordPress Theme Development & Customization
  • WordPress Migration & Upgradation
  • WordPress Maintenance & Support

To discover more about our WordPress development services, visit http://www.conceptinfoway.net/technology/wordpress-development-india/.

 

SAVE YOUR TIME AND MONEY

Save your time and money by choosing us, a scalable team with 120+ professionals with expertise in various domains and technologies.

Dedicated TL / PM with Quick Response

Have a dedicated Team Lead / Project Manager for your each project, all with an assurance that your project will get utmost priority, along with the quick and firm response for all your queries regarding it.

QUICK, SECURE AND SWIFT CODE

With expertise on all the latest architectural and coding structures, our experienced developers ensure that the site is secure, and performs quick and swiftly.

Leave us your info

Select Service

Describe your requirement here

Upload An Attachment