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.

WordPress database is easy to use with simple, but if you want to handle the data that does not conform to the provided initial table structure, or considering the use of as the CMS, you should create a newly table as a better case.
This plugin provides the ability to be able to add a new table freely in the database (direct on MySQL) of WordPress in such a case, and can be management of data in a simple user interface. However, since the plugin version 2.x, you need to be PHP version 5.4 or more on the environment.
When you use the various shortcodes, built-in methods, and APIs that is provided a rich on this plugin, WordPress might be transformed into a powerful CMS.
<a href="https://ka2.org/cdbt/" rel="nofollow ugc">Please see here for more documentation of the plugin</a>. 
All official development on this plugin is on GitHub. Published version will bump here on WordPress.org. You can find the repository at <a href="https://github.com/ka215/cdbt" rel="nofollow ugc">https://github.com/ka215/cdbt</a>.
Detailed documentation has published at the site of author. If you are free, Please try to qv.
<ul>
<li><a href="https://ka2.org/cdbt/v2/" rel="nofollow ugc">Version 2.x related documentation</a></li>
<li><a href="https://ka2.org/cdbt/v1/" rel="nofollow ugc">Version 1.x related documentation</a></li>
</ul>
(Sorry, for about documentation will be only the Japanese version currently.)

Custom DataBase Tables

Hi,
I am using Custom DataBase Tables plugin to create custom tables in database. Its really great. I need to create a password field which needs to be md5 encrypted. how can we do that in this plugin.

password field in table

Using this database management tool, You can create freely own table in  MySQL database, and do input and output of data in an intuitive operation.

Pitta Migration vs Custom DataBase Tables