This is a quick guide on backing up the database of your WordPress website with a simple plugin. In WordPress, to completely backup your websites you need to first backup the files and then the database. Most of the people are able to easily backup the files with the help of different types of File Manager available with Graphical User Interface such as the file Manager provided in cPanel.
Although phpMyAdmin Interface is also provided with cPanel, by going into which you can manually back up your WordPress site’s database manually, still the interface for that is non-familiar to just every other user. It is a bit technical. That’s why for all of the non-technical users backing up WordPress Database with a plugin is an easy solution.
The plugin that we’ll use for this purpose is WP Migrate DB. It is primarily developed to edit & backup the database for migration purposes. But you can use it for general database backups as well.
It is quite a popular plugin with 3,00,000+ installs.
This plugin has the Free as well as the Paid version. The free version is good to go for our purpose of backing up the database. The Free version even allows you to edit the database with Find & Replace option. This option is helpful when you are migrating your WordPress site to a new URL.
Steps to Backup WordPress Database With WP Migrate DB Plugin
Given below are the steps to follow in order to successfully backup your WordPress site database. I assume here you’ve successfully downloaded and installed this plugin in your WordPress site, if not, do it first, the link for the plugin is already provided above. Also, activate it.
Go to your WordPress Dashboard, go to Tools and then WP Migrate DB option.
This will open the plugin interface as shown in the following screenshot. It has got several options.
You need not deal with most of the options if you are only using it for backup purposes. Focus on the very first option, that is the Export option. You got four options here:
- You can save the uncompressed database in SQL format on your hosting server. (Uncheck Both Export Options)
- You can save the compressed database in SQL GZIP format on your hosting server. (Check Only Compress with GZIP option)
- You can download the uncompressed database in SQL format on your computer. (Check Only Save as file to your computer option)
- You can download the compressed database in SQL GZIP format on your computer. (Check both the Export options)
You can choose any of the above options as per the way you like to backup the database of your WordPress Blog or website.
Some advanced options are also provided as shown in the following screenshot.
Checking the Find & Replace option will allow you to replace any of the existing details to new details. For example, if your current website URL is https://www.example.com and you want it to be https://example.com on the new database, then you can specify the existing URL in the OLD one and New one in the New URL side. The Old URL & Old file path is automatically fetched and shown here in this interface. I’ve intentionally removed them here.
Again, for backup no need to deal with this option. Likewise, under Advanced Options, you can do several things like Exclusing post revisions or spam comments to reduce the overall size of the database. You can also replace GUIDs or make the DB backup compatible with older versions of MySQL.
In the end, if you want to backup frequently your WordPress Database, you can check the Save Migration Profile and it will save your current settings for next time as well.
In the end, simply click on the Export option and it will start exporting your Database. It may take time because it backs up the database, table by table. More the number of tables will be in your DB, it’ll take more time.
The progress popup clearly displays the ongoing table(s) backup process. It also shows the time and option to hide the tables. One good thing here is the Pause feature. You can Pause the backup process and can resume it as well.
Once this will approach to 100%, the database will be either downloaded or saved to your hosting location as per the Export option preference previously set by you.
The time it took to complete the backup process is also shown. One thing I’d like to tell about this plugin can really help you save a lot of time backing up large databases.
Go to the Settings Tab of this plugin and you’ll see the Max Request Size option.
You can increase this Maximum Request Size upto the extent you feel your web server is capable of handling easily. For example, in my case, I just set it to the max limit of 25 MB. There is no save button here but it saves your preference as soon as you drag the value to the desired value.
I’ve used this plugin to even backup some WordPress sites with databases sizes of hundreds of MBs. This is also one of my always to install type plugin in any of the WordPress sites.
If you need to back up the entire WordPress Site (Files + Backup) easily in one-click, then follow my tutorial, link for which is given below. In this tutorial, I’ve also guided to restore the backup. It can also be used to migrate complete WordPress site from one server to another.
Hope, this tutorial helped you in backing up your WordPress website or blog’s database. Feel free to share your views or to ask any questions in the comments section below. Also, share this article with others who might need help for the backup of their WordPress site Database.