Override database config for WordPress multisite

Just came up with a solution to this issue posted here https://stackoverflow.com/questions/12958123/override-wp-siteurl-and-wp-home-for-wordpress-multisite/

Basically you do not copy the wp_site and wp_blogs tables to your development installs when pulling in a production database, and have pre-configured them locally for your development URLs. You then leverage a network-wide plugin to set the WP_SITEURL and WP_HOME values based on configuration in wp-config.php.

Will likely turn this into a plugin once I have time to test it further.

Hope that helps!

Related Posts:

  1. What are options are there to implement a multi language site
  2. Where is the robots.txt stored for a WordPress Multisite install?
  3. Settings API in Multisite – Missing update message
  4. WordPress Multisite Multiple child theme
  5. WordPress Multisite: How to make all media library items available for every site?
  6. How to setup LDAP authentication with WP multisite
  7. Create multiple subdomains for multi-site from a database
  8. How to map a specific multi-site blog to a folder?
  9. WordPress Multisite. Can domain be used instead of subdomain?
  10. Built to scale, or worry later?
  11. Multisite Subdomains result in 403 Forbidden
  12. Set subdomains live in a next step
  13. Is there any fundamental difference in developing a wordpress multi-network site?
  14. merging two multisites
  15. W3 Total Cache Plugin with WP 3 MultiUser [closed]
  16. Should multi-language site using multi-site architecture have default language in base site?
  17. Multisite Installation: how do I setup global search?
  18. favicon and multi site
  19. Register email as username
  20. Two WordPress sites sharing the same database
  21. Recover from failed multisite conversion
  22. Help with updating a wp_get_sites to get_sites and sorting by alphebetical order
  23. Multisite Subdomain Using More Resources Than Others?
  24. Can I use multisite functions in a single-site installation?
  25. Multisite – create new site with precreated pages, menu etc
  26. Add custom user fields in Multisite USERS page
  27. WordPress multisite with multiple parent domains
  28. WP 4.4 – domain mapping for sites within a multisite network?
  29. Can I use two different domain names with a WordPress multisite network?
  30. Restrict Admin Capabilities in MultiSite
  31. Installing multisite on domain with existing subdirectory wordpress installations
  32. wp_redirect not working on admin menu page
  33. How to disable the default WordPress redirect to non-www URLs?
  34. Bulk theme settings in wordpress multisite
  35. Permalinks not working using wordPress Networking with custom post types
  36. Should I use a multisite installation to achieve a multi-language site?
  37. Multisite domain naming
  38. Site kit Google Analytics setup giving Error: {“error”:”invalid ‘redirect_uri'”}
  39. Can is_page and is_front_page both be true?
  40. Switch a single site to a multi-site
  41. migrate a MU sub blog to a single install
  42. Preferred method of setting user role only works on Main Site in Network
  43. How to share primary navigation of main site with subsites usining switch_to_blog
  44. WordPress 4.5+ Multisite Domain Mapping
  45. Register submenu on network menu from the subsite
  46. new multisite, old db
  47. Multisite sub-directories IIS 7.5 change media/uploads location
  48. One Domain, Two Installs of WordPress
  49. add_rewrite_rule not working in WordPress Multisite
  50. Create a page for a theme only
  51. How do I find where the current value of the option ‘registration’ in the SQL database?
  52. Can’t access Dashboard of a Multisite WordPress. Chrome results in “ERR_TOO_MANY_REDIRECTS”
  53. is_main_site() Always Returns True
  54. How do I get the site url from a Block (within the block editor)
  55. Strange multisite issue where all sites return same id with get_current_site()
  56. Permalink with a Category and then a Post
  57. Creating a subdomain network in a subdomain
  58. Multisite – One Site with multiple URLs
  59. Sub-sub folders of WordPress Multisite subdirectory
  60. Delete all user’s meta without knowing all the ‘key’
  61. Allow editors to switch sites (Multisite)
  62. moving tables between multisite installs
  63. How much resources are good enough for 3.9.2
  64. Best Practise: Linking to WPMU sites from other sites
  65. Stylesheet and JS linking error in WP multisite nested path
  66. Common user login for two different wordpress installation and bbpress
  67. Can I run multiple blogs from my local machine
  68. Trouble with SQL SELECT inside switch_to_blog()
  69. WordPress Multisite and how to apply sef urls only to specific sites
  70. Custom css – WordPress Multisite
  71. Migrating from domain mapping plugin to native domain mapping
  72. how to convert a wp multisite into a single site with content from subsites
  73. Getting stylesheet error after setting subdomain to false in multisite
  74. “Multisite support is not enabled.” After Multisite Config Changes
  75. String translation within WordPress multisite with i18n not working on all sites
  76. Add new sites on the same level as the parent URL in a multisite
  77. Search returns “Nothing Found” on a sub directory
  78. Add radio button on theme at the select of the theme the same theme should be activated after generation of new site in multi site
  79. Moving wordpress multisite to new domain
  80. Users getting linked unwanted to main mu in WordPress multisite (WPMU)
  81. WordPress automatic Login on other page?
  82. Multisite: How to bypass wpmu_signup_user_notification and add my own notification logic?
  83. Changed singlesite to multisite, but new site shows Maintenance
  84. multisite shared settings
  85. Multi Site Translate Strings
  86. Multisite Demo Data for New Site
  87. Responsive Wordress Site – Serve different post types to each device
  88. Should I use MultiSite for a subdomain based wp site?
  89. Can’t import posts in multisite
  90. User registration problem on multisites web
  91. How to apply specific plugins to affect all sites (Multisite Network)
  92. Admin user getting redirected to /wp-admin/user
  93. Getting 404 after Update in Multisite
  94. Is there a way to have wordpress 301 versus 302 urls by default?
  95. first load of the page gives 404 error
  96. Some Subdomains on a Multisite Install Not Found
  97. personal_options hook on WordPress multisite
  98. Multi site root site installed on subdomain, with child sites as subdirectories
  99. Integrating WordPress for blog and other content pages in a web app
  100. Redirect to Multisite site 2 if site 1 has a setting