How to Replace the Old Blog Domain URL in the WordPress Database

In this guide, we will provide you with detailed steps on how to perform this change correctly within your WordPress database. By following these instructions, you can avoid unwanted damage to your website and ensure that your new URL is consistently updated across the WordPress platform.

Step 1: Backup Your Website

Paketsolusi.com - Before initiating the process of replacing the old blog domain URL in the WordPress database, it is crucial to back up your website. Backing up your data will protect your information and allow you to restore your site if any errors occur during the process. Make sure you have the latest copy of your website before proceeding.

Step 2: Access Your WordPress Database

To replace the old blog domain URL in the WordPress database, you first need to access your website's database. You can do this through your hosting control panel or by using database management applications like phpMyAdmin.

Step 3: Locate the wp_options Table

Once you have accessed your WordPress database, you need to locate the wp_options table. This table stores various settings for your website, including the blog's domain URL.

Step 4: Edit the URL Values in the wp_options Table

Within the wp_options table, search for the rows with the option_name column named "siteurl" and "home." Click on the option_value column for both rows and change the values to your new domain URL.

UPDATE wp_options SET option_value = replace(option_value, 'olddomain.com', 'newdomain.com') WHERE option_name = 'home' OR option_name = 'siteurl'; UPDATE wp_posts SET post_content = replace(post_content, 'olddomain.com', 'newdomain.com'); UPDATE wp_postmeta SET meta_value = replace(meta_value, 'olddomain.com', 'newdomain.com'); UPDATE wp_comments SET comment_content = replace(comment_content , 'old_domain.com', 'newdomain.com');

Ensure that you replace the URL values carefully and input the correct URL. This change will update your website's URL across the WordPress platform.

Step 5: Update the Permalinks

Within the wp_options table, search for the rows with the option_name column named "siteurl" and "home." Click on the option_value column for both rows and change the values to your new domain URL.

Ensure that you replace the URL values carefully and input the correct URL. This change will update your website's URL across the WordPress platform.

Source :https://wordathemes.com/replace-old-blog-domain-url-in-wordpress-database/