How to Backup WordPress Database Using cPanel, Plugin and phpMyAdmin

Backup WordPress Database

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.

If you are already using a backup plugin like BackupBuddy or BackWPup, then chances are that you are already making database backup automatically.

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.”

Install and activate WP-DB-Backup plugin to backup WordPress database.

After activating, open the WP-DB-Backup plugin page by navigating to “Tools > Backup.”

Open WP-DB-Backup settings page by navigating to Tools and then 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.

Select all the database tables you want to backup.

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.

Select Download to your computer option to download database backup immediately.

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.

WordPress databse backup progress.

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.

Schedule WP-DB-Backup to backup WordPress database.

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.

Select Backup Wizard in the cPanel.

The above action will open the cPanel Backup Wizard page. Here, select the option “Backup.”

Select the option Backup in the Backup Wizard.

Since we are only going to backup the database, select the option “MySQL Databases” in the Full or Partial backup page.

Select MySQL Databases option in Backup Wizard.

If you have multiple databases, then select the database you want to backup.

Select your WordPress database 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.

Find and click on the option phpMyAdmin option in the cPanel.

Now, select the database you want to backup from the left sidebar.

Choose your database in phpMyAdmin panel.

The above action will open the database. Here, click on button “Export” appearing on the top navigation bar.

Choose the option Export in phpMyAdmin.

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.

Select the export method, format and click on the Go button to download WordPress database.

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.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.