Pitta Migration

Description

This plugin is aimed at developers that need to migrate their databases from
production to test or local domains.

This is the simplest way I’ve found to migrate databases quickly.

You only have to set the WP_HOME
(WordPress address URL)
and WP_SITEURL
(Blog address URL)
constants once for each environment and then the database is automatically
upgraded when you import a database and login to the admin area.

This stands on the shoulders of the constants and fills the hole for when
plugins don’t follow the rules and use the database directly.

This plugin is designed to be the most lightweight way to migrate your database
and stay out the way of your own processes.

It works with WordPress to use WordPress’ own constants to update the database
using the
WordPress Database Object.
It avoids search and replaces in text files. It uses database queries to update
the database as should be done.

Most developers have their own methods for exporting/importing the database –
if you can use mysqldump then you probably don’t want a WordPress plugin to
do it for you.

It makes no assumptions about your database and it’s cross platform.

P.S. Pitta is taken from the start of an answer from WordPress SE:

Deployment of a WordPress site from one box to another has been a PITA since
day one I started working with WordPress. (Truth-be-told it was a PITA with
Drupal for 2 years before I started with WordPress so the problem is
certainly not exclusively with WordPress.)

So this plugin aims to make things less PITA and more yummy Pitta (pedants will
mention that Pitta can also be spelled pita).

Its inspiration actually comes from the second answer
from the same WordPress SE question.

Coincidentally there is a migratory bird called a Pitta:

The fairy pitta migrates from Korea, Japan, Taiwan and coastal China to Borneo.

P.P.S. This plugin is based off the excellent WordPress Plugin Boilerplate from antichris on Github

Screenshots

Installation

1. Upload pitta-migration directory to the /wp-content/plugins/ directory
2. Insert the WP_HOME and WP_SITEURL constants into your wp-config.php file
3. Activate the plugin through the ‘Plugins’ menu in WordPress
4. As soon as you activate the plugin it will try to migrate the database to match the constants

FAQ

I’ve imported my database to migrate and set WP_HOME and WP_SITEURL but nothing happens

Check the the plugin is active. If you’re just restored a production database the plugin might have been deactivated there.

As soon as you activate the plugin it will try to do the migration.

It’s active too…

Check if it has run, by looking in the wp_options table for home and siteurl, as the session might have had problems and not displayed the message.

Reviews

The best I know

oekoplatt December 6, 2016

works perfectly Thank You

Contributors & Developers

Changelog

0.4.2

• Bug fix: Mark tested for WordPress v4.3, crop the screenshot

0.4.1

• Bug fix: Update this change log, remove trailing spaces

0.4.0

• Improvement: Add in a translations

0.3.4

• Improvement: Add in a screenshot

0.3.3

• Bug fix: The ‘migrated to’ URLs were showing the old ones

0.3.2

• Adding antichris as a contributor

0.3.1

• Bug fix: Missed off switching the setup view to stop using the admin_notices hook

0.3.0

• Bug fix: Switched to using admin_notices as the default hook instead of admin_init as the notice would sometimes not appear

0.2.1

• Removed excess logging

0.2.0

• Put the plugin into an object
• Used the WordPress Plugin Boilerplate from antichris on Github

0.1

• The initial plugin that worked but was very basic