theantichris

icc97

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 <code>WP_HOME</code> 
(<a href="https://codex.wordpress.org/Editing_wp-config.php#WordPress_address_.28URL.29" rel="nofollow ugc">WordPress address URL</a>) 
and <code>WP_SITEURL</code> 
(<a href="https://codex.wordpress.org/Editing_wp-config.php#Blog_address_.28URL.29" rel="nofollow ugc">Blog address URL</a>) 
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 
<a href="https://codex.wordpress.org/Class_Reference/wpdb" rel="nofollow ugc">WordPress Database Object</a>. 
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 <code>mysqldump</code> 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 <a href="http://wordpress.stackexchange.com/a/182/5433" rel="nofollow ugc">answer from WordPress SE</a>:
<blockquote>
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.)
</blockquote>
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 <a href="http://wordpress.stackexchange.com/q/119/5433" rel="nofollow ugc">second answer</a> 
from the same <a href="http://wordpress.stackexchange.com/q/119/5433" rel="nofollow ugc">WordPress SE question</a>.
Coincidentally there is a migratory bird called a <a href="https://en.wikipedia.org/wiki/Pitta" rel="nofollow ugc">Pitta</a>:
<blockquote>
The fairy pitta migrates from Korea, Japan, Taiwan and coastal China to Borneo.
</blockquote>
P.P.S. This plugin is based off the excellent <a href="https://github.com/theantichris/WordPress-Plugin-Boilerplate" rel="nofollow ugc">WordPress Plugin Boilerplate</a> from antichris on Github

Pitta Migration

Migrate WordPress databases using WP_HOME and WP_SITEURL constants.

samwilson

<a href="http://tabulate.readthedocs.org/en/latest/?badge=latest" rel="nofollow ugc"></a> 
<a href="https://travis-ci.org/tabulate/tabulate" rel="nofollow ugc"></a> 
<a href="" rel="nofollow ugc"></a> 
<a href="" rel="nofollow ugc"></a> 
<a href="https://wordpress.org/plugins/tabulate" rel="ugc"></a> 
<a href="" rel="nofollow ugc"></a> 
<a href="https://github.com/tabulate/tabulate/blob/master/LICENSE.txt" rel="nofollow ugc"></a> 
<a href="https://scrutinizer-ci.com/g/tabulate/tabulate/?branch=master" rel="nofollow ugc"></a>
This plugin provides a simple user-friendly interface to tables in your database. 
Somewhat akin to phpMyAdmin, but easier to use and more focused on end users.
The documentation can be found at <a href="https://tabulate.readthedocs.org/" rel="nofollow ugc">tabulate.readthedocs.org</a>.
Features (in no particular order):
<ol>
<li>Tables can be filtered by any column or columns, and with a range of 
operators (‘contains’, ‘is’, ’empty’, ‘one of’, ‘greater than’, ‘less than’, 
and the negations of all of these). Multiple filters are conjunctive 
(i.e. with a logical and).</li>
<li>Access can be granted to read, create, update, delete, and import 
records in any or all tables. (This can be done by anyone with the 
promote_users capability.) Access can also be granted to anonymous users.</li>
<li>CSV data can be imported, with the UI supporting column mapping, data 
validation, and previewing prior to final import. If an imported row has a 
value for the Primary Key, the existing row will be overwritten.</li>
<li>Data can be exported to CSV, including after filters have been applied. </li>
<li>A quick-jump navigation box is located top right of every page, 
and can also be added as a Dashboard widget.</li>
<li>Records in tables with date columns can be viewed in a calendar.</li>
<li>Entity Relationship Diagrams (drawn with <a href="http://graphviz.org/" rel="nofollow ugc">GraphViz</a>) 
can be automatically generated, with any specified subset of tables. Foreign 
keys are displayed as directed edges. This feature is only available if the 
<a href="https://wordpress.org/plugins/tfo-graphviz/" rel="ugc">TFO Graphviz plugin</a> is installed.</li>
<li>All data modifications are recorded, along with optional comments that users 
can provide when updating data.</li>
<li>The <code>[tabulate]</code> shortcode can be used to embed tables, lists, row-counts, 
and data-entry forms into WordPress content. For more details, 
<a href="https://tabulate.readthedocs.org/en/latest/shortcode.html" rel="nofollow ugc">read the documentation</a>.</li>
<li>Tables with point columns can be exported to KML and OpenStreetMap XML. 
Also, data entry for these columns is done with a small slippy map, on which 
a marker can be placed.</li>
</ol>
Development is managed on GitHub 
at <a href="https://github.com/tabulate/tabulate" rel="nofollow ugc">github.com/tabulate/tabulate</a>

Tabulate

Manage relational tabular data using the full power of your MySQL database. CSV import/export; access-control; foreign-keys; and lots more.

Pitta Migration vs Tabulate