Manually Backup WordPress Database

As a site owner, creating a WordPress Database backup is very important. And you, you should always setup a WordPress backup system as well, in order to help you keep WordPress site secure.

This would allow you to restore your website when unexpected things happen.

There is plenty of ways in order to backup WordPress. In most cases, many will recommend you to use some plugin.

In this article, we will show you how to create a WordPress database backup manually through the database with phpMyAdmin.

How To Manually Backup WordPress Database Using phpMyAdmin

The first thing you need to do is log in to your WordPress hosting control panel (cPanel).

Then, go to the Databases section and click on phpMyAdmin.

cPanel's phpMyAdmin

This will launch the phpMyAdmin window. In the left-hand pane look for the WordPress database name and click on it.

In our example, we have the database name, testdb.

You will be able to see the list of WordPress database tables that correspond to what you have selected, as you can see in the image below:

WordPress Database Table Structure

From here, you have two options to manually backup WordPress database:

  1. Quick
  2. Custom

In this guide, we’ll try both methods.

1. Quick Backup Method

Make sure your WordPress database is selected inside phpMyAdmin (refer to image above). If it isn’t, then click on your WordPress database name to select it.

Once the database is selected, click on Export tab from the top menu bar.

Ensure that the Quick option is selected, and then, click Go.

Quick WordPress Database Backup Method

You should be prompted for a file to download. Save the file to your computer. And, depending on the database size, this may take a few minutes.

2. Custom Backup Method

Using the same procedure as in Method 1 except this time, ensure that the Custom option is selected. This will give you more options to explore.

In some instance, WordPress plugins add their own tables to your database. If there are any tables that you don’t like included from your export, then just unselect them. If you are unsure, then it is better to just keep them all selected.

Custom WordPress Database Backup Method

The Output section

By default, phpMyAdmin will show you the output of the export process as text. In order to change it you have to select the Save output to a file option. For compression, you need to select zipped or gzipped option as illustrated in the image below:

Custom Backup Output Section

The Format section

Ensure this setting to SQL.

The Format-specific options section

Select Include a timestamp of when databases were created, last updated, and last checked. And leave the rest as it is.

Custom Backup Format-specific Section

Scroll down to Object creation options.

Select Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT / TRIGGER statement.

Custom Backup Object-creation Section

And finally, scroll down to the bottom of the page and click on the Go button.

You should be prompted for a file to download. Save the file to your computer. And, depending on the database size, this may take several minutes.

We hope this article helped you learn how to manually backup WordPress database from phpMyadmin. You can also check our guide on how to reset WordPress admin password.