Add new domain to ‘My Sites’ using network admin

In the rare case that someone needs this, I was able to accomplish extra sites but I had to do everything through the database (not ideal). Here’s the comment I left for myself in wp_config.php:

 /* If you need to add more domains to this installation it is sadly a 
 * ballache as there's no way of doing it through the admin. 

 * In the database you need to edit the following tables:

 * wp_site - add a new domain row (make note of site ID)
 * wp_sitemeta - duplicate all the new domain meta data
 * wp_blogs - add a new domain here, match the site_id foreign key

 * Then you need to duplicate the following tables:

 * wp_i_commentmeta
 * wp_i_comments
 * wp_i_links
 * wp_i_options
 * wp_i_postmeta
 * wp_i_posts
 * wp_i_term_relationships
 * wp_i_terms

 * Finally go into wp_users and ensure a wp_i_capabilities and wp_i_user_level
 * exists for your new site ID. You should then be able to see and edit your
 * new domain.

Related Posts:

  1. Add additional Network constants to wp-config.php dynamically
  2. How do I change the Multisite URL?
  3. Post and Page Inheritance to subsites in a WordPress Network
  4. Roles other than Super admin accessing manage_network_themes
  5. How to add super admin to all sites
  6. Listing of all site options in dashboard
  7. Multisite: How to store global options vs. site options?
  8. Single-user registration to access all sites in WordPress MultiSite Network
  9. WPMU vs WordPress MultiSite is there a difference anymore?
  10. Generate a user list per site to communicate upgrade plans
  11. Timeout While Upgrading Network in Multi-site
  12. “Upgrade Network” error: stuck with SSL certificate verification
  13. Favicon plugin for WordPress running in network mode (multisite)? [closed]
  14. No Network/Super admin after enabling Network
  15. Problem in Internationalizing a plugin built for network level usage
  16. Multisite network admin – URL / redirect error
  17. Change Username?
  18. Why does the My Site dropdown show only a single domain?
  19. WP Multisite – domain mapping to domain.com and separate site to domain.com/help
  20. Is there a way to run upgrade.php for one blog?
  21. Include only a domain path in multisite Network
  22. Possible to enqueue scripts and CSS to Multisite Network dashboard?
  23. Adding new sites to Multisite won’t register in Dashboard
  24. WordPress Network admin options page: how to store options and where will they be stored?
  25. Multi-Site Subdomain: Show master site under subdomain if no sub site exists
  26. How to force change Network site multi language subdirectory base URL?
  27. Merge Multisites with Shared Network Media Library
  28. Multisite Subdirectory with same domain subdomain
  29. How to create a Multi-Network subsite?
  30. Create Custom Multisite User Role to Reduce Capabilities
  31. Renaming admin user on multisite install by MySQL
  32. HTTPS Warning and Certificate Error when Updating Network
  33. Multisite, with virtual root
  34. How to exclude specified from all list of Multisite
  35. How to wordpress multi site [closed]
  36. Network of multisites in WordPress, create new site with all the contents of the main
  37. How do I check if the user is a site owner in a network?
  38. Locking one blog of many in a multi user/blog WordPress installation
  39. Programmatically creating site in a network
  40. switch_to_blog() not functioning while querying post_types, Why?
  41. WordPress Multisite with subdomains on different domains
  42. Can’t create a subdomain network – and WP is installed in webroot, not a folder
  43. How to have one installation at blog.example.com and multiple blogs in sub folders such as blog.example.com/userA?
  44. Forward and mask a WordPress website
  45. WordPress multisite with same content
  46. Can I use the same Folder name as a Multisite Blog?
  47. unable to access network admin of a blog
  48. Website not listed under Sites (in a Network environment)
  49. Sites network with sub-folders
  50. How can I create network with different domains?
  51. multisite – unable to connect to network administration
  52. Add Network Sites are not working
  53. Getting stylesheet error after setting subdomain to false in multisite
  54. Admin users not able to see network menus
  55. How to hold posts and accounts for moderation on WordPress Network site
  56. My Sites link in multisite is incorrect
  57. Multisite network admin login redirect
  58. Multisite network subdomains doesn’t work
  59. Cannot enable WordPress Network – ‘MULTISITE’ already defined and false
  60. Change header.php of a specific WordPress Multisite
  61. Modify new user email notification in network admin screen wp multisite
  62. the menu of the network does not display my second website
  63. WordPress Multisite – Auto enable theme
  64. Issue when transforming an existing site to multi-site with subfolders setup
  65. network admin pages not linked to correctly
  66. How to split database of WordPress multi-site network into multiple database
  67. Move two independent sites to network
  68. How to configure CNAMES to be part of a WordPress Network
  69. Cannot access network admin panel on multi site
  70. How to apply specific plugins to affect all sites (Multisite Network)
  71. Admin user getting redirected to /wp-admin/user
  72. Getting 404 after Update in Multisite
  73. 4th Network Site Database Errors?
  74. Can admins on network install view and edit users accounts?
  75. How to display update message only to admin
  76. How to disable admin access on new site registration for user in Multisite?
  77. WordPress Multisite (Network) some site users added to main site users list as subscriber
  78. Multisite Network Admin
  79. something in database is causing me to not be able to log into network admin of multisite
  80. Unexpected Login Redirect in Localhost WordPress Sites
  81. Multisite logged into one wp-admin, move to another sites wp-admin asked to login again
  82. Why does WordPress connect to site URL through internet in order to load pages
  83. How to use WordPress Multisite With Different Domain Names?
  84. How To Add Custom Form Fields To The User Profile Page?
  85. Where are available Roles Defined in the wp_ database?
  86. restore_current_blog() vs switch_to_blog()
  87. Can i merge 2 new WP_Query($variable) ‘s?
  88. How to disable a network enabled plugin for just one site?
  89. How to reliably flush rewrite rules on multisite?
  90. Site Redirecting to wp-signup.php
  91. Moving a WP Multisite to a subdirectory
  92. Cookies in multisite where network sites have their own domain name
  93. Convert a Multisite WordPress install into a Single site
  94. WordPress MultiSite Active Directory integration and site privacy
  95. WordPress Job Interview Preparation
  96. How to add Custom Blog Options to new blog setup form?
  97. How can I trust switch_to_blog()?
  98. Remove the blog slug from WordPress Multisite root node
  99. Why are my roles not visible in a Multi-site/Network?
  100. Site admin in a network install can’t edit users?

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)