Having regular backups of your WordPress site is one of the most important things that you should do, no matter how busy or lazy you are.
In case you are wondering, all your WordPress data like the posts and pages are stored in the database itself.
But unlike regular backups, you sometimes may want to backup WordPress database only.
The reasons include but not limited to modifying database tables, performing maintenance, executing custom queries, etc.
In those scenarios, you should always backup WordPress database before applying any changes.
So, if you ever need, here is how you can easily backup WordPress database in three different ways, using the WordPress plugin, cPanel backup options and phpMyAdmin (manual method).
Backup WordPress Database using WP-DB-Backup
Using WP-DB-Backup to backup WordPress is really easy and you don’t need any technical skill whatsoever.
First off, download the plugin from the WordPress repository and install it like any other WordPress plugin.
Once installed, activate the plugin by clicking on the link “Activate Plugin.”
After activating, open the WP-DB-Backup plugin page by navigating to “Tools > Backup.”
By default, WP-DB-Backup will pre-select all the native WordPress tables to backup.
If you want to backup all of your database, then select all the checkboxes on the right side.
You can use the Shift key on your keyboard to quickly select all the checkboxes.
After selecting all the required tables to backup, scroll download, select the radio button “Download to your computer” and click on the button “Backup Now” under the Backup Options section.
The above action will start the backup process.
Once the backup process has been completed, the backup file will be downloaded to your computer automatically.
If you want to, you can select the other options like “Save to server” or “Email backup to” as the backup destinations.
Moreover, you can also schedule the regular database backups using this plugin.
Just scroll down and configure the scheduling options as required.
That’s all there is to do.
Backup WordPress Database using cPanel
Using cPanel to backup WordPress database is pretty easy as the panel itself provides the required backup tools.
To start off, login to your cPanel, find and click on the link “Backup Wizard.”
Quick tip: You can use the provided search bar in the cPanel to quickly filter the options.
The above action will open the cPanel Backup Wizard page. Here, select the option “Backup.”
Since we are only going to backup the database, select the option “MySQL Databases” in the Full or Partial backup page.
If you have multiple databases, then select the database you want to backup.
That’s all there is to do. With the above action, the backup of your selected WordPress database will be downloaded automatically.
Backup WordPress Database Manually
Just like the other two ways discussed above, you can use phpMyAdmin to backup WordPress database manually.
Actually, learning the manual way to backup your WordPress database is very important and helps you in several situations.
To start off, open your cPanel, find “phpMyAdmin” and click on it to open the phpMyAdmin panel.
Now, select the database you want to backup from the left sidebar.
The above action will open the database. Here, click on button “Export” appearing on the top navigation bar.
Here in this Export page, make sure that the backup format is set to “SQL” and click on the “Go” button to backup WordPress database.
Unless you know what you are doing, don’t select the radio button “Custom.”
The custom option is strictly intended to advanced users.
That’s all there is to do and it is that simple to backup WordPress database using the WP-DB-Backup plugin, cPanel and phpMyAdmin.
Hopefully that helps and do comment below if you ever face any problem or just sharing your thoughts and experiences about using the above methods to backup WordPress database manually.