How To Create A WordPress Database Backup Manually from phpMyAdmin

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.

2017-09-06T01:31:04+00:00

About the Author: Rodney Lacambra

Rodney Lacambra is the founder and editor of WPMakeSite Blog and is a freelance WordPress Developer by profession. Learn more about him here and connect with him on Facebook, Twitter, Google+ and LinkedIn.

4 Comments

  1. Mostafiz May 26, 2017 at 9:58 pm - Reply

    Wow!! Such a detailed article. Liked your work. Thanks for creating such a great and helpful article.

    • Rodney Lacambra July 15, 2017 at 11:27 am - Reply

      Hey @Mostafiz, glad you found this guide useful. Thanks for dropping by.

      ~Rod

  2. Tanmay June 3, 2017 at 12:05 am - Reply

    hey Rodney
    very nice article I really find it very informative thank you
    keep it up for the good work

    • Rodney Lacambra July 15, 2017 at 11:29 am - Reply

      Hey @Tanmay,

      Thanks for finding this helpful. Keep coming back for great and informative WordPress articles.

      ~ Rod

Leave A Comment

8 Shares
Share8
Tweet
+1
Share
Pin
Stumble

Wait! Don't go just yet.

Get more WordPress tips only shared with email subscribers. Just enter your name and email address below.

This information will never be shared for third part