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!