https://www.siteground.com/kb/change-domain-wordpress-multisite/

Dear support, i need to change the primary domain for network. I read this article
https://www.siteground.com/kb/change-domain-wordpress-multisite/
It is written :
Below you can find the steps needed to update the five values mentioned (table prefix is shown as wp_ in the examples below. If your database uses a different table prefix, replace wp_ in the following table names with your prefix):

wp_options: lines named “siteurl” and “home”
wp_site
wp_sitemeta: the entry named “siteurl”
wp_blogs: any entries in the “domains” column that have the old domain name
wp_#_options: As every sub-site will have sets of tables that correspond to the blog_id in the wp_blogs table. You need to navigate to the wp_#_options table, where # corresponds to the blog_id, and update the “siteurl” and “home” values in the table.

But i do not know where to find these value.

thank you in advance.
Hadi

  • Huberson

    Hello Hadi
    You will need to access your multisite database to replace any occurrence of the old domain with the new one. This can be done with a database management software like MySQL Workbench or PHPMyadmin via server/hosting panel.

    The values you need to edit are located under 'databaseprefix_site', 'databaseprefix_sitemeta', 'databaseprefix_blogs', 'databaseprefix_options', 'databaseprefix_options' tables. And the the sub-sites 'wp_#_options' tables.



    In above multisite database, the 'databaseprefix' is 'wpmu', you will have to look for your specific database prefix.
    There might be a couple sub-sites' options table('wp_#_options' ), make sure to locate them all and change their 'siteurl' and 'home' value.

    Cheers,
    Huberson

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.