How To Create A WordPress Database Backup Manually from phpMyAdmin

Last updated on
Share
Tweet
Share
Email

As a site owner, creating a WordPress Database backup is very important. And you, you should always set up 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.

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.

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.

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.

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:

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.

Scroll down to Object creation options.

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

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.

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

Share
Tweet
Share
Email
Our Most Popular Post Right Now!
Disclosure: Some of the links on this site are “affiliate links”, which allow me to earn a small referral payment if you choose to purchase the product or service.

4 Responses

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

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

    1. Hey @Tanmay,

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

      ~ Rod

Leave a Reply

Your email address will not be published.

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

Recommended Book: WordPress All-in-One For Dummies
Subscribe to Blog via Email
Enter your email address to subscribe to this blog and receive notifications of new posts by email.
This field is for validation purposes and should be left unchanged.

Don’t worry, we hate spam as much as you do.
Do you need help setting up WordPress?
I can help you with blog and site setup, full website build, performance & security, maintenance and support, and many more.
Recommended Web Hosting