Moving the domain of a WordPress Multisite Install108

Moving the domain of a Wordpress Multisite Install
Author: InfoBeep - September 20, 2019 | subject to copyright

Are you looking for the way of moving the WordPress site with Multisite but you are not sure where to start from, this article is for you. The below given can help you to save your precious time. In the Multisite installation, the domain as well s the path gets populated more times in the database. Because of that, it needs a few more tweaks for getting up and run. So let’s have a look at the way to move the domain of WordPress multisite install.

Ways to move the domain of WordPress Multisite install:

  • First of all, take the backups of your file and database
  • transfer all the web files and the database to your new server
  • Open your config file (wp-config.php) and update all the database connection and the fields:


// ** MySQL settings – You can get this info from your web host ** //

/** The name of the database for WordPress */

define(‘DB_NAME’, ‘your_db’);


/** MySQL database username */

define(‘DB_USER’, ‘yourusername’);


/** MySQL database password */

define(‘DB_PASSWORD’, ‘this-is-your-password’);


/** MySQL hostname */

define(‘DB_HOST’, ‘localhost’);


/** Database Charset to use in creating database tables. */

define(‘DB_CHARSET’, ‘utf8’);

  • After config file, open htasscess file (.htaccess) and update/confirm the line : RewriteBase/
  • After completing all the setup in the file, Login to your PHPMyAdmin and open your database
  • Open the “wp_options” table and change the “site_url” and “home” field
  • open the “wp_blogs” table and change all the domains and paths for the entries
  • Same as in “wp_blogs”, open the “wp_site” table and adjust the path and domain
  • After that, open the “wp_sitemeta” table and adjust the “site_url” field
  • For each of the blog, WordPress Multisite stores the standard WordPress with the increment prefixi i.e. wp_1, wp_2. wp_3w, and so on. So you should open the “wp_*_options” table for each and change the “site_url” and “home” fields
  • After completing all the above-mentioned changes, we need to run the SQL command for updating the GUID for all the blogs incrementing the table:

                                                                                                                                                                                        UPDATE wp_posts SET guid = REPLACE (guid,



  • Repeat the above-given process and replace the “guid” with “post_content”
  • Once you complete all the above-given process, your site is ready to go. Run your site.

For a quick look, this is a list of the tables you will need to update with your new domain name:

  • wp_options > siteurl
  • wp_options >home
  • wp_site
  • wp_sitemeta > siteurl
  • wp_blogs > domain (change this for all instances that use your old domain)
  • wp_*_options > siteurl (the “#” refers to the blog ID of additional sites in your network)
  • wp_*_options > home
  • wp_*_options > fileupload_url

Now it’s time to be ready to roll. If you get any kind of connection message, it might be because some paths are not correct. If you get the white and blank screen, it might be because any of the templates are not in the place. It’s best to check all the active templates location.


Moving the domain of a WordPress Multisite shouldn’t be time-consuming and difficult and the above-given steps can be helpful for you. If any error occurs, you can restore your site and try again.