Change & Update WordPress URLs

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

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,

Also read

We are now Using the Latest Exchange Server

Talk to Our Experts! Drop Your Contact Details
and we will get back to you asap.
Recent News Post
The Role of Excellent User Experience (UX) in Custom CMS Design
Jun18

The Role of Excellent User Experience (UX) in Custom CMS Design

In the rapidly evolving digital landscape, user experience (UX) has emerged as a critical factor in the success...
View More
Optimizing Website Performance: Tips for Faster Load Times in 2024
Jun14

Optimizing Website Performance: Tips for Faster Load Times in 2024

In the digital age, the performance of your website can make or break your online presence. Slow load...
View More