Change & Update WordPress URLs – Concept Infoway

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

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

Using SQL Commands to Change & Update WordPress URLs

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 with WordPress URLs?

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,

For more information, contact us at sales@conceptinfoway.com. You can also get in touch with us by filling out a simple form here or by calling us at +91 98250 31415. Let us help you unlock the full potential of your website with our WordPress development services. Also, follow us on Facebook.

Also read

 

Talk to Our Experts! Drop Your Contact Details
We will get back to you ASAP.
Recent Blog Posts
View More
Who is Using Drupal?
Jul17

Who is Using Drupal?

Many new businesses are wary of going for Drupal-powered websites. It is not only open source, but it...
View More
View More
Calculate First and last day of week/month in SQL
Mar26

Calculate First and last day of week/month in SQL

View More