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

Fig 1. Install WordPress Buddy+ Site Extension

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

Select Extensions

Click +Add

Select Choose Extension

Scroll to find WordPress Buddy+

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:

Fig 2. Application Settings > Connection Strings

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

Fig 3. MySQL In-App Blade

WordPress Tools

Fig 4. WordPress Tools

When using multiple connection strings, select the appropriate database

Displays list of Active Plugins and provides an option to Disable All Plugins

Update Home and SITE_URL in WP_OPTIONS table by updating fields

Used to update passwords

MySQL Migration

Overview

Fig 5. Migration Assistant

List of databases (from connection strings)

Downloadable .SQL files on the server

Help – description of features

Import .SQL to MySQL Database

Export a MySQL Database to .SQL

Delete .SQL files listed in (2)

Import

Fig 6. Import Menu

Select .SQL file to import

Select Database to import TO

Click to begin the import

Export

Fig 7. Export Menu

Clicking the button will export all databases listed in connection strings