Giving your existing WordPress MultiSite a new domain name on Microsoft Azure

Artikel
04/06/2015

Prerequisites:

This article assumes you acquired a new domain name and have configured the DNS Zones.
If you haven't already done so, see the article here: Configuring a custom domain name for a Microsoft Azure Web Site

Problem:

You installed WordPress through the MS Azure Gallery and setup a MultiSite (WP feature).
However, now that you’re ready for launch, you decide you want to change the name from: https://<sitename>.azurewebsites.net to: https://newsite.com/ while remaining hosted on Azure.

If you already have your custom domain name pointing to your WP instance and now want to enable MultiSites, then please follow this article here: Convert Azure WordPress MultiSite

If you do not have MultiSites enabled, there are easier solutions you should be following.

Make a backup!

Before we get started, I kindly ask that you make a backup of both your Azure Website. Here is a link that show you how to accomplish this. Azure Web Sites Backup

Getting Started:

Using a MySQL client, connect to your MySQL database.

Verify that WordPress is the only application using the database.

If there are other tables unrelated to WordPress on your database, you'll have to ensure you do not modify those in anyway.

Step 1. Export your MySQL database

Using MySQL Workbench or similar MySQL client, select the Export menu.

Select all the WP tables for exporting and be sure to select "Export to Self-Contained File".

Step 2. Find / Replace in Notepad

Open the .SQL file in notepad. Do not open this file up in something like MS Word or some fancy editor.
We want a simple editor that will not modify end-of-line characters or anything of that sort.

Do a find->replace of <sitename>.azurewebsites.net to newsite.com. Replace All.