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.

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

Recent News Post
This is Why You Should Consider HTML5 for Mobile App Development
Jan20

This is Why You Should Consider HTML5 for Mobile App Development

There are plenty of reasons to why HTML5 is the best for cross-platform mobile app development. It facilitates...
View More
What is the Cost of Android App Development in India?
Dec16

What is the Cost of Android App Development in India?

Planning an android application for your business is a great idea. But, finding a reliable android app development company or...
View More