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
(WordPress address URL)
(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
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).
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
pitta-migrationdirectory to the
- Insert the
WP_SITEURLconstants into your
- 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
- 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_optionstable for home and siteurl, as the session might have had problems and not displayed the message.
- Bug fix: Mark tested for WordPress v4.3, crop the screenshot
- Bug fix: Update this change log, remove trailing spaces
- Improvement: Add in a translations
- Improvement: Add in a screenshot
- Bug fix: The ‘migrated to’ URLs were showing the old ones
- Adding antichris as a contributor
- Bug fix: Missed off switching the setup view to stop using the
- Bug fix: Switched to using
admin_noticesas the default hook instead of
admin_initas the notice would sometimes not appear
- Removed excess logging
- Put the plugin into an object
- Used the WordPress Plugin Boilerplate from antichris on Github
- The initial plugin that worked but was very basic