Microsoft Azure Open Source Development Support Team Blog

Support for Open Source Technologies on Microsoft Azure App Service

WordPress Tools and MySQL Migration with WordPress Buddy+

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

  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:


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


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