icc97

theantichris

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.

Pexle Chris

The best database management tool for the best CMS.
This plugin uses the tool <a href="https://www.adminer.org/" rel="nofollow ugc">Adminer</a>, in order to give database access to administrators directly from the Dashboard. 
As simple as the previous sentence!
I am not the author of Adminer. I am only the author who does the WordPress integration with Adminer. 
Author of Adminer is Jakub Vrana and you can donate him from <a href="https://www.paypal.com/donate/?item_name=Donation+to+Adminer&cmd=_donations&business=jakub%40vrana.cz" rel="nofollow ugc">there</a>.
Compatible also with WordPress Multisite installations
<h3>WP Adminer access positions</h3>
You can access the WP Adminer from the below positions: 
1. WP Adminer URL in the Admin Bar 
2. WP Adminer Tools Page (Dashboard > Tools > WP Adminer)
<h3>Explore my other plugins</h3>
<ul>
<li><a href="https://www.pexlechris.dev/library-viewer/wp-wpadminer" rel="nofollow ugc">Library Viewer</a>: With Library Viewer, you can display the containing files and the containing folders of a “specific folder” of your (FTP) server to your users in the front-end.</li>
<li><a href="https://wordpress.org/plugins/gift-wrapping-for-woocommerce" rel="ugc">Gift Wrapping for WooCommerce</a>: This plugin allows customers to select a gift wrapper for their orders, via a checkbox in the checkout page.</li>
</ul>

Database Manager – WP Adminer

thanks for this plugin! easy to use and well structured!
you can easily edit your DB or whatever :)

very useful!

Thank you for this Adminer plugin! 

It has been a very long time (when ARI Adminer was taken offline) and is so very necessary as a database tool without having to bother clients for their database credentials.

Pieter

Adminer is back!

I've tried other Adminer solutions over the years - always having various connectivity issues, often being unable to connect to the DB.

This one always seems to connect correctly - great job!

Actually works!


Great plugin! This is what i was looking for.


Working as expected!


This is a solid database admin tool that has always worked for me, even on a variety of client sites running on a variety of hosting.



Much appreciated.


Solid database admin tool that has always worked

Manage the database from your WordPress Dashboard using Adminer.

Pitta Migration vs Database Manager – WP Adminer