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
- Upload
pitta-migration
directory to the/wp-content/plugins/
directory - Insert the
WP_HOME
andWP_SITEURL
constants into yourwp-config.php
file - Activate the plugin through the βPluginsβ menu in WordPress
- 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.
Contributors & Developers
“Pitta Migration” is open source software. The following people have contributed to this plugin.
ContributorsTranslate “Pitta Migration” into your language.
Interested in development?
Browse the code, check out the SVN repository, or subscribe to the development log by RSS.
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 ofadmin_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