Import a WordPress MySQL Database using WordPress Buddy+ on Azure App Service

This post discusses how to use the Azure Web App Site Extension, WordPress Buddy+, to import a WordPress MySQL Database (.sql file) into MySQL In-App.

If you haven’t already, review and install (link here) the WordPress Buddy+ Site Extension for Azure Web Apps. The steps below require MySQL In-App to be enabled.

Import Steps

  • From Kudu CMD console (<webappname>.scm.azurewebsites.net), browse to D:\home\SiteExtensions\WPBuddy\sqldumps\ folder.
  • From your desktop, drag and drop the .sql file into sqldumps folder
  • Launch WP Buddy+ Site Extension
  • Click on Migration
  • From the Menu, Select Import
  • Select the .SQL file from the drop-down. If the file you copied is not visible. Revisit step 2 and ensure the extension is .sql
  • Select the Database to Import To [For MySQL In-App, choose: 127.0.0.1 (azuredb]
  • Click Start Import!

Once the import has finished, ensure the settings in wp-config.php is accurate for MySQL In-App.

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

  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

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