How to Change & Update WordPress URLs in the Database when Site is Moved to a New Server

How to Change & Update WordPress URLs in the Database when Site is Moved to a New Server

Alex
June 3, 2017

Change & Update WordPress URLs – 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 like Change & Update WordPress URLs while moving site to new location, kindly contact our WordPress developers at https://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 https://www.conceptinfoway.net/technology/wordpress-development-company-in-india/.

Recent News Post
iPhone 14 and iPhone 14 Pro – Let’s Learn More About its Features, Specs, and Prices
Oct11

iPhone 14 and iPhone 14 Pro – Let’s Learn More About its Features, Specs, and Prices

Finally, the wait is over, and the legendary iPhone 14 by Apple Inc. is here to spellbind all...
View More
Hire Qualified ASP.Net Developers to Explore New Business Horizons in 2022
Sep20

Hire Qualified ASP.Net Developers to Explore New Business Horizons in 2022

In 2022, it is fruitful in many ways to hire asp.net developers – ASP.NET development is affordable, secure,...
View More