This document explains how to update the site URL when moving a WordPress Multisite installation from an old domain to a new domain. The process includes updating the primary domain in Ensure you have a complete backup of the WordPress files and database. Ensure you have access to the WordPress server In this post, we will explain how to change the site URL on the newly moved domain.<\/p>\n Step 1: Open the wp-config.php and edit define(‘DOMAIN_CURRENT_SITE’, ‘newdomain.com’);<\/p>\n Step 2: Open MySQL or phpMyAdmin and run the following query.<\/p>\n After updating 1. Why do we need to update 2. Why should we take a database backup first?<\/strong> 3. Do I need to update the domain in the database?<\/strong>wp-config.php<\/code> and replacing the old domain references in the WordPress database.<\/p>\n\n\n\nPrerequisites<\/h2>\n\n\n\n
wp-config.php<\/code>. Ensure you have MySQL\/phpMyAdmin access with appropriate database permissions. Confirm that the new domain is configured and pointing to the correct server. Identify the correct WordPress database and table prefixes before running SQL queries. Verify the old and new domain names carefully before performing the replacement. If the site uses SSL, ensure the new domain has a valid SSL certificate.<\/p>\n\n\nImplementation<\/h2>\n
define('WP_DEBUG', false);\ndefine('WP_ALLOW_MULTISITE', true);\ndefine('MULTISITE', true);\ndefine('SUBDOMAIN_INSTALL', false);\ndefine('DOMAIN_CURRENT_SITE', 'newdomain.com');\ndefine('PATH_CURRENT_SITE', '\/');\ndefine('SITE_ID_CURRENT_SITE', 1);\ndefine('BLOG_ID_CURRENT_SITE', 1);<\/pre>\nUPDATE wp_options SET option_value = replace(option_value, 'http:\/\/olddomain.com', http:\/\/newdomain.com') WHERE option_name = 'home' OR option_name = 'siteurl';\n\nUPDATE tmp6d400b_posts SET guid = replace(guid, 'http:\/\/olddomain.com','http:\/\/newdomain.com');\n\nUPDATE tmp6d400b_posts SET post_content = replace(post_content, 'http:\/\/olddomain.com', http:\/\/newdomain.com');\n\nUPDATE wp_postmeta SET meta_value = replace(meta_value,'http:\/\/olddomain.com','http:\/\/newdomain.com');\n\nUPDATE wp_site domain='http:\/\/newdomain.com' where id=value\n\nUPDATE wp_blogs SET domain='http:\/\/newdomain.com' WHERE blog_id=value;<\/pre>\n\n\n
Conclusion<\/h2>\n\n\n\n
wp-config.php<\/code> and the required database entries, the WordPress Multisite installation will use the new domain. Clear the WordPress\/server cache and verify the main site, network admin, and individual sites to ensure they are loading correctly. It is recommended to test all site URLs and functionality after the domain migration.<\/p>\n\n\n\nFAQs<\/h3>\n\n\n\n
DOMAIN_CURRENT_SITE<\/code>?<\/strong>
It tells WordPress Multisite the primary domain used by the network.<\/p>\n\n\n\n
The SQL queries modify multiple database tables. A backup allows the database to be restored if an incorrect replacement is performed.<\/p>\n\n\n\n
Yes. WordPress Multisite stores domain information in several tables, including wp_site<\/code>, wp_blogs<\/code>, and site-specific tables.<\/p>\n\n\n\nRelated Articles<\/h2>\n\n\n\n