Dear support, i need to change the primary domain for network. I read this article
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_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.

  • Huberson
    • Recruit

    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.


Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.