Change & Update WordPress URLs

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

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.


  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

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

Also read

We are now Using the Latest Exchange Server

Table of Contents

Recent News Post
React Native for Web: A Deep Guide from Concept Infoway

React Native for Web: A Deep Guide from Concept Infoway

React Native has revolutionized the way we develop mobile applications. By allowing developers to write code in JavaScript...
View More
.NET 8: What’s New? (Features & Release Date)

.NET 8: What’s New? (Features & Release Date)

In the ever-evolving world of software development, staying up-to-date with the latest technologies and updates is crucial. For...
View More