Moving WordPress can be a cumbersome process. Especially migrating your website to a new server involves many different steps which can take a lot of time.
The hardest part, however, is moving the MySQL database.
Especially with when it’s of a certain size, downloading the database from the old server and uploading it to the new location can be a test of patience.
In addition to that there are often unforeseen problems such as timeouts in phpMyAdmin and other errors.
Plus, you need to replace all mentions of the site’s old location with that of its new home, either via MySQL statements or the search and replace script.
No wonder this part is one of the least favorite WordPress-related activities for both users and developers.
However, what if there was a tool which made the process of migrating the WordPress database as easy as a few button clicks? Which could dramatically cut down on the time and effort spent on this step?
Well, WP Migrate DB Pro is just that tool.
What is WP Migrate DB Pro And What Does it Do?
As the name suggests, WP Migrate DB Pro by Delicious Brains is a premium WordPress plugin that helps you move your WordPress database from one place to another.
It comes with recommendations from the highest echelons in the WordPress sphere. The plugin’s fans include Pippin Williamson of Pippin’s plugins, Chris Coyer from CSS-Tricks, and Genesis developer Carrie Dils.
Why does it deserve that kind of fame?
Well, WP Migrate DB Pro does away with 95% of the work usually involved with migrating a WordPress database.
Instead of downloading the database to your hard drive and then uploading it again, WP Migrate DB Pro allows you to sync it directly between two sites.
That means the plugin can push or pull a WordPress database from one site to another. Not only that, it will also replace the URL and file path of the old location with that of the database’s new home.
These capabilities make it a formidable tool for moving a WordPress website from development to live environment as well as keeping an updated version on your hard drive.
Let’s take a peek under the hood then.
How to Use WP Migrate DB Pro
Before you can install the plugin, you first need to make sure your environment meets its requirements, which are as follows:
- Latest or second-latest version of WordPress
- PHP 5.2.4+
- MySQL 5.0+
- Apache 2+ or Nginx 1.4+ (will likely work with other PHP/MySQL web servers, yet not officially supported)
- Firefox and Webkit-based browsers like Chrome or Safari. Internet Explorer is not supported.
After installation, you will find it in the Tools section of the WordPress backend. The fact that the plugin doesn’t create its own menu item is already a plus in my book.
WP Migrate DB Pro can fulfill three main functions:
- Export the database of your current site (the
This article was written by Nick Schäferhoff and originally published on WPKube.