How to change the main site url on a multisite installation (network)?

For those of you without the required sql knowledge. The steps below can be used to change your main site url variable on a network installation.

Assumption:

  • Windows Operating system
  • MySQL Admin basic tasks
  • WinGrep

Steps:

  1. Download mysql dump.sql of your full wordpress database
  2. While using wingrep find all matches for @url then replace with @newURL
  3. Upload the dump file with the new variables replaced
  4. Change your wp_config.php file to the newURL

You are done!

Related Posts:

  1. Does WordPress keep track of a post’s URL history and provide automatic redirects?
  2. Override default url for author pages?
  3. Multiple endpoints to same page
  4. Custom slug in front of search URL
  5. How to prevent redirection to max 2147483647 for larger values of the page query variable?
  6. how to add prefix to post url structor only
  7. Why does wordpress still strip my query var?
  8. Appending numbers to url do not break the link
  9. Hijacking the URL for filtering
  10. WP Login forms action URLs displayed as pretty URLs in browser (ex with Restore Password)
  11. custom htaccess rewrite rule for page
  12. Passing & Reading URL Parameters with URL re-writing
  13. How to change page URLs to “www.site.com/page” instead of “example.com/blog/page” but keep post URLs as “example.com/blog/post”?
  14. Add_query_arg + two times the same argument?
  15. WordPress 404 unless there is a space in url
  16. Change default URL of image attachment
  17. Prevent WordPress from automatically correcting URLs
  18. Taking a value from PHP_URL_PATH won’t work after WordPress 5.5 update
  19. Display content according to current URL
  20. Server (WordPress) redirects files that are not supposed to (using htaccess)
  21. add_rewrite_rule not registering on Multisite
  22. Change WordPress comments url / word
  23. How to get “extended” path info from URL in a plugin
  24. How to check current URL for endpoint in a template file?
  25. add_rewrite_rule not working for language specific characters
  26. Custom URL rewrite to specific page template
  27. Rewrite Custom Post Type URL slug
  28. Define orderby in url
  29. Alias ‘wp-content’ directory to something shorter (framework?)
  30. WordPress .htaccess – route other URLs to another app
  31. open all .docs in word online
  32. How to add custom variable in url without redirect?
  33. Adding pretty query parameters
  34. Changing RSS feed URL structure
  35. Append a query string to the end of every URL
  36. add_rewrite_rule fro html to another url not working
  37. Preserve Domain Alias
  38. WordPress redirects non-existing url to existing ones – how to disable
  39. How to rewrite url wordpress?
  40. How to building pretty URLs to reflect category hierarchy?
  41. How to build custom route by adding taxonomies to URL ? ex: www.demo.com/communities/palo-alto/
  42. Wildcard forward all posts and pages with few exceptions
  43. Help with Rewrite Rule for Custom Post Type with Query String
  44. A clean custom rewrite rule for weekly archives
  45. Right url for custom post type
  46. Preserve old website URL structure after migrating to WordPress
  47. I want to add a new tag to WordPress URL permastruct
  48. Add language prefix to permalinks
  49. How to redirect large amount of URLs?
  50. How to change the Author Slug from Username to Nickname and deal with Special Characters
  51. Per Page Permalink Structure for Page Post Type
  52. ReWrite rule for files of a previously standalone blog moved to network
  53. Rewrite /category/cars into /topics/cars
  54. URL renaming issue
  55. Removing “www” from a site URL
  56. Adding a query string to only one page url
  57. custom wordpress rewrite
  58. Two sets of url one content?
  59. How to customize sub-URLs in a wordpress website (.htaccess)
  60. Weird characters behind every single link and images
  61. How to use wp rewrite to hide form action url?
  62. Rewriting a date hierarchy into a ‘yyyy-mm-dd’ slug
  63. How to Force WWW. in Domain With WordPress MU Domain Mapping Plugin?
  64. URL problem: www.sitename.com/blog and www.sitename.com/learn using same WP installation
  65. custom url – add attachment’s id or name after post
  66. How do I get posts to appear at mydomain.com/blog?
  67. remove archive from url :: marketpress
  68. Make the home page’s slug visible in the browser’s URL bar
  69. dynamic URL rewrite
  70. add_rewrite_rule with optional parameters
  71. How to change search page url so that it still returns a page when there’s no search query specified?
  72. Append a parametter at first or last to a certain URL
  73. Allowing multiple URLs for same Post
  74. How to create dynamic URLs on WordPress?
  75. Dynamic URL with rewrite rule not working
  76. i want to change URL of WordPress image or rewrite in runtime
  77. How to Update / Change URL when Popup Modal Loads?
  78. Multiple permalink with and without category for same post
  79. Passing a variable to hyperlink text?
  80. Param causing 404
  81. url redirect none www to www
  82. Root-relative paths being rewritten on ‘Edit Page’ [closed]
  83. How to remove Base URL Duplication?
  84. Get custom posts by segment of the URL
  85. Get parameters and custom page template
  86. Direct Dynamic URL in root to a location within template
  87. Use Parent Pages for URL Structure without Landing Page
  88. taxonomy term in URL slug won’t forward to the correct term for custom post like it does for default categories/normal posts
  89. Remove Page Slug from URL
  90. How to create short urls for sharing and downloadable content?
  91. How to stop WordPress creating URLs that don’t exist
  92. How to put a Custom Folder under one sub-site of Multisite WP?
  93. Rename page URL
  94. WordPress post-type create url rewriting
  95. How to prevent URL-modification when page title contains digits only?
  96. How to exclude my home page from url of my internal pages?
  97. How do I display a friendly URL link in the frontend?
  98. Please give me the rewrite rules for my ugly urls
  99. Lost WordPress website access after changing URL [closed]
  100. Remove url parameter using wordpress