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.

Delicious Brains

Backup your database instantly, send the backup via email, or schedule backups to run automatically.
Database Backup for WordPress allows you to quickly back up your core WordPress database tables, and either download the backup as a gzipped file, or send it via email to an address you choose.
By default, the plugin will always back up all the core WordPress database tables. However, you may also selectively back up any custom tables that might be created by other plugins
Additional options include the ability to exclude spam comments from the comments table, or post revisions from the posts table, saving you space and bandwidth.
You can also enable scheduled backups to run automatically at set intervals, and configure the email address to send the scheduled backups to.
<h4>Backup Before You Mess Up</h4>
Backups are the one thing you don’t think of until you need them. You might have the best web host, the most secure server, and a tried and tested process for running plugin, theme, or core updates. But all it takes is one little thing to go wrong, and you lose your entire website.
You need a reliable and automated solution which backs up your WordPress data and sends it to an off-site location. Database Backup for WordPress is that solution.
<h4>Why You Should Back Up Your Website</h4>
As much planning as you do, any CMS like WordPress that stores its data in a database is vulnerable. Hardware, software, and security hiccups are rare, but they do happen. Even the best enterprise systems in the world have multiple levels of backup in place.
Think about the data you store in your WordPress site. Your blog posts since the day you launched the site. Your customers, products, and order history if you run an ecommerce site. Backups are like implementing an insurance policy for your data. With backups, you have a reliable way of restoring that data if anything goes wrong.
Simple, automated backups save you time and give you peace of mind that you are prepared for the worst case scenario, even if you never need it. Better to have it and not need it, than to not have it and suddenly need it.
<h4>Scheduled Backups</h4>
Depending on your needs, you might want to back up your database every few minutes, hourly, daily, weekly, or monthly. You’ll want to automate this process, or it becomes another possible point of failure.
Scheduled backups give you peace of mind that your data is being backed up as much or as little as you need, without your intervention. By emailing the backups to an email address you choose, you can verify that the backup has run, and store it in a safe location.
<h3>Translators</h3>
Thanks to the following people for providing translation files for Database Backup for WordPress:
<ul>
<li>Abel Cheung</li>
<li>Alejandro Urrutia</li>
<li>Alexander Kanakaris</li>
<li>Angelo Andrea Iorio</li>
<li>Calle</li>
<li>Daniel Erb</li>
<li>Daniel Villoldo</li>
<li>Diego Pierotto</li>
<li>Eilif Nordseth</li>
<li>Eric Lassauge</li>
<li>Friedlich</li>
<li>Gilles Wittezaele</li>
<li>Icemanpro</li>
<li>İzzet Emre Erkan</li>
<li>Jong-In Kim</li>
<li>Kaveh</li>
<li>Kessia Pinheiro</li>
<li>Kuratkoo</li>
<li>Majed Alotaibi</li>
<li>Michał Gołuński</li>
<li>Michele Spagnuolo</li>
<li>Paopao</li>
<li>Philippe Galliard</li>
<li>Robert Buj</li>
<li>Roger</li>
<li>Rune Gulbrandsøy</li>
<li>Serge Rauber</li>
<li>Sergey Biryukov</li>
<li>Tai</li>
<li>Timm Severin</li>
<li>Tzafrir Rehan</li>
<li>吴曦</li>
</ul>
<h3>Past Contributors</h3>
filosofo, skippy, Firas, LaughingLizard, MtDewVirus, Podz, Ringmaster

Database Backup for WordPress

Very good plugin thanks, it does what it says.

Works great

This is an excellent database plugin. I have daily host-level backups, and once a month I take a full cPanel backup, but as a belt and braces approach I now have daily database backups being sent to an email address, and filtered to a backup folder. Hope I never need them, but if I do I will be relieved to see these archived.

Install, activate, setup and forget ... until needed

Database Backup for WordPress is your one-stop database backup solution for WordPress.

Pitta Migration vs Database Backup for WordPress