WordPress Buddy+ site extension for Azure App Service on Windows

WordPress Buddy+ is an Azure Web Apps Site Extension that facilitates WordPress configuration and especially useful for WordPress migrations. It has features for updating HOME and SITE_URL, viewing list of plugins and updating passwords. In addition, it can also help migrate the MySQL database, whether it be MySQL In-App, ClearDB or on a Virtual Machine (VM).

Installation

In the Azure Portal, select Web App and scroll to Development Tools section

1. Select Extensions
   
2. Click +Add
   
3. Select Choose Extension
   
4. Scroll to find WordPress Buddy+
   
5. Confirm the Legal Terms and click OK
   

If you need additional help installing this or other Site Extensions, check out the article here.

---

Prerequisites – Connection Strings

ClearDB or MySQL Server on VM

If using ClearDB or MySQL on VM, ensure that the connection string is in place within application settings.

The format is as follows: Database=<db name>;Data Source=<host name>;User Id=<username>;Password=<password>

Example:

MySQL In-App

When using MySQL In-app, the connection string is created automatically. Ensure In-app is enabled.’

Fig 3. MySQL In-App Blade

---

WordPress Tools

Fig 4. WordPress Tools

1. When using multiple connection strings, select the appropriate database
2. Displays list of Active Plugins and provides an option to Disable All Plugins
3. Update Home and SITE_URL in WP_OPTIONS table by updating fields
4. Used to update passwords

---

MySQL Migration

Overview

Fig 5. Migration Assistant

1. List of databases (from connection strings)
2. Downloadable .SQL files on the server
3. Help – description of features
4. Import .SQL to MySQL Database
5. Export a MySQL Database to .SQL
6. Delete .SQL files listed in (2)

Import

Fig 6. Import Menu

1. Select .SQL file to import
2. Select Database to import TO
3. Click to begin the import

Export

Fig 7. Export Menu

1. Clicking the button will export all databases listed in connection strings
   

Clean-up

Fig 8. Clean-up

1. Delete all .SQL files