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,
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:
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.