Being a WordPress user, you may need to shift from your existing server to a new server. There are two methods of migrating your database, i.e. using the phpMyAdmin manually and installing a powerful plugin. As the manual procedure is quite lengthy, developers prefer using a plugin to migrate WordPress database to a new server. If you like to use plugins more than codes, you can use a plugin for shifting your WordPress site conveniently.
In this article, we have discussed the reasons and methods to migrate WordPress database to a new server with the help of WP-DBManager.
Reasons to Migrate WordPress Database
Although there are tremendous numbers of reasons to migrate your WordPress database to a new server, expansion of the website is the primary reason. The need for migration arises when your existing server no more manages to cope up with the content or database. Apart from it, you may desire to shift your WordPress database to a better domain.
This migration is highly effective if done properly as it is resulted in improved SEO results and increased number of visitors. Therefore, if you feel any of the reasons is appropriate for your website, you should choose to migrate your WordPress site.
Introduction to WP-DBManager
There are tremendous numbers of plugins that may assist you in creating a backup of your existing database and restore on the new server. Listed among the category of these plugins is the highly efficient and powerful WP-DBManager plugin. We recommend you to use this plugin because it renders a user-friendly interface. This plugin allows you to perform the migration procedure even if you don’t have much technical knowledge about WordPress. Adding to it, you can optimize, backup and repair your existing database by using this plugin efficiently.
However, the most attractive feature of WP-DB Manager is the ability to manage the backup and to configure the database options to meet your WordPress migration needs. Therefore, you can use this plugin and implement the following method to migrate WordPress database.
Method to Migrate WordPress Database by Using WP-DBManager
Before implementing the migration procedure, it is imperative for you to install a fresh version of WordPress on the temporary URL. This can be done by following the basic method of installing WordPress. Once done, it is time to start working with WP-DBManager.
To begin with, you primarily need to install the WP-DBManager plugin on your existing server. You can do this by navigating to the Plugins menu after logging into your existing WordPress dashboard. Here, you should choose the Add New option and search for wp-dbmanager. You can click on Install Now option for activating the plugin; just like you activate any other plugin on your WordPress site.
Upon the activation of WP-DBManager plugin, you should create a backup of your existing site’s database. For this, you need to log into the dashboard of the existing host and dig into the Database option located at the left side of the panel. Here, you need to find the “Backup DB” option and choose it. Now the plugin checks your database and comes up with a customized report message.
You can move to the next step when the backup status says “Excellent. You are Good to Go”. This ensures that you can click on the Backup option available at the bottom of the page and find a success message like “Database Backed Up Successfully on September 19, 2014 @ 10:22am”.
The last step in successfully creating a backup of your existing WordPress database is downloading the newly created backup. You can do this by clicking on the Download button available next to the recently created backup.
Uploading and Importing Database
With the completion of the backup procedure, you have a way through in the process of migrating WordPress database. Now, as you have a backup on your desktop, it is time to upload this backup on the server. The backup of your existing database can be saved as a .sql file. You need to find this file on your desktop and upload it to your wp-content/backup-db directory. You can do this in either of the two ways, i.e. either with FTP or through the file manager in your server’s cPanel.
Once you have uploaded the file, it’s time to execute certain tasks on your hosting account. For this, you need to log into the WordPress dashboard and go to the Manage Backup DB option located in the Database. In this list, you can find the backup file that you uploaded. Choose the database backup from the list and click on Restore. A success message can pop up on the screen like “Database on September 19, 2014 @ 10:22am restored successfully”.
This marks the completion of the migration procedure, and you can witness your data that was presented on the previous server has migrated to the new server.