Backing up your website is one of the most critical steps for securing your data, yet it’s often overlooked by many website owners. In our experience, regularly creating backups can save you from unexpected issues and data loss.
Manually backing up your WordPress database is a simple way to safeguard all your website’s data. While it doesn’t include your entire WordPress site, it’s a handy solution for quickly recovering your database in case of problems.
In this article, we will guide you through the steps to manually back up your WordPress database so you’re always prepared to restore your data when needed.
Here is a quick overview of the topics we will cover in this tutorial:
- When and Why Make a WordPress Database Backup Manually?
- Making a WordPress Database Backup Using a Plugin
- Backing Up WordPress Database Manually Using phpMyAdmin
- Creating a Manual WordPress Database Backup From cPanel
- Restoring a WordPress Database Backup
- Set Up a Proper Automated Backup System for the Future
When and Why Make a WordPress Database Backup Manually?
Installing and setting up a WordPress backup system for your site is important. It ensures you can quickly restore your site if anything goes wrong, a practice that has proven essential for many users.
There are several situations where manually backing up your database becomes necessary. Knowing when to do this can save you a lot of trouble down the line.
For example, if you’re planning major changes to your WordPress website, having a recent database backup provides extra peace of mind before you make any updates.
If you still have access to your website’s admin area, you can easily use a plugin to create an on-demand backup (we’ll show you which plugin to use later in this article).
However, there are cases where you might not have access to the admin area of your site.
For instance, this can happen when your WordPress site is hacked or becomes inaccessible due to a WordPress error, which is a scenario we’ve come across many times before.
Bonus Tip 💡: Need to help clean up a hacked WordPress site? Take a look at our Hacked Site Repair service. For a small fee, our team of WordPress security experts will clean up and restore your website in no time.
In such situations, you’ll need to create a fully manual backup using a database management utility (we’ll guide you through this process as well).
A manual database backup works just like plugin backups, offering the same level of data security and recovery options.
With that said, let’s take a look at how to easily create a WordPress database backup manually.
1. Making a WordPress Database Backup Using a Plugin
This method is easier and recommended, but it will only work if you have access to your WordPress website’s admin area.
First, you need to install and activate the Duplicator plugin. For more details, see our tutorial on installing a WordPress plugin.
Note: There is also a free version of Duplicator, which can be used to create database backups. We recommend upgrading to the paid version because it offers more features.
Upon activation, you need to go to the Duplicator Pro » Backups page and click the ‘Add New’ button.
On the next screen, Duplicator allows you to choose what you want to include in the backup.
Select ‘Database Only’ and then click on the ‘Next’ button.
Duplicator will now scan your WordPress site and database.
After that, it will show you the scan results. A notice may appear next to the Database section informing you that you are creating a database-only package.
Just click on the ‘Create Backup’ button to continue.
Duplicator will now prepare your database backup in the background and show you the progress.
Once finished, you will be able to download the backup files. We recommend downloading both the Archive and Installer files, as this will allow you to restore your website more easily.
2. Backing Up WordPress Database Manually Using phpMyAdmin
For this method, we will use phpMyAdmin. It is an open-source software that allows you to manage your MySQL database using a web-based interface.
phpMyAdmin comes pre-installed on most WordPress hosting providers.
For the sake of this article, we will show you screenshots from Bluehost. However, the basic procedure is the same for most hosting providers.
First, you need to log in to your WordPress hosting control panel and click on the ‘Settings’ button under your website.
Under your website settings, scroll down to the Quick Links section.
Next, click on the ‘phpMyAdmin’ button to continue.
This will launch the phpMyAdmin app in a new browser tab.
From here, click to select your WordPress database from the left column and then click on the ‘Export’ button at the top.
You will be asked to select the export method.
Next, you need to select ‘Custom,’ as it will give you more options to explore.
Once you choose the Custom option, it will show all your selected tables in your WordPress database.
Sometimes, WordPress plugins add their tables to your database. If there are any tables that you would like to exclude from export, then you can deselect them. If you are unsure, it is better to keep them all selected.
You now need to scroll down to the ‘Output’ section.
By default, phpMyAdmin will show you the output of the export process as text.
You need to change that by selecting the ‘Save output to a file’ option.
For compression, you must select the zipped or gzipped option.
Now, scroll to the bottom of the page and click on the ‘Go’ button. phpMyAdmin will send you the database export as a zip or gzip file.
That’s all. You have successfully made a manual WordPress database backup.
3. Creating a Manual WordPress Database Backup From cPanel
Most good WordPress hosting companies also offer easy ways to download on-demand backups. Here is how to make a manual WordPress database backup from your hosting dashboard.
Hosting providers like Bluehost, SiteGround, and HostGator all have similar options.
For the sake of this tutorial, we will show you screenshots of Bluehost. However, the basic procedure is quite similar for other hosts.
First, log in to your hosting account dashboard and click the ‘Settings’ button under your website.
On the next screen, you need to switch to the ‘Advanced’ tab.
From here, simply scroll down to the cPanel section and click the ‘Manage’ button.
This will launch the cPanel interface in a new browser tab.
From here, just scroll down to the files section and click the ‘Backup’ button.
On the backups page, scroll down to the partial backups section.
From here, you need to click on your database name to download your database backup file.
You can also download the backup of your WordPress files from this page if you need to.
Restoring a WordPress Database Backup
Once you have downloaded the WordPress database backup, you can continue fixing your hacked WordPress site or make any other changes you need to.
In many cases, you probably won’t need to restore your website from the backup.
But if you do, we have a detailed step-by-step guide on restoring WordPress from backup. It covers all common WordPress backup options, including restoring from a database backup.
Set Up a Proper Automated Backup System for the Future
You can manually make WordPress database backups, but remember that this is not an alternative to a proper backup solution for your WordPress site.
You may not have access to your WordPress database in certain situations. For example, this can happen if your hosting company suspends your account or loses your website data.
Another possible scenario is when a hacker injects malicious code into your WordPress database. Cleaning an infected database will be much more difficult.
That’s why we suggest using a proper backup plugin to automatically store your WordPress database backups on the cloud.
We recommend using Duplicator. It automatically creates and stores your backups on a cloud storage service like Google Drive, Dropbox, OneDrive, and more.
You can see this guide on how to automatically back up WordPress for detailed instructions.
We hope this article helped you learn how to manually make a WordPress database backup. You may also want to see our guide on how to restore your WordPress site with just a database backup or our expert picks of the best WordPress database plugins.
If you liked this article, then please subscribe to our YouTube Channel for WordPress video tutorials. You can also find us on Twitter and Facebook.
Hajjalah
I usually backup my database manually using the phpMyAdmin because it enables you to only include the necessary files. But I am wondering about the accuracy of this method because some times some tables do not turn up when restore the backup is restored. I do not know why. Is there a special step one can make to avoid loss of data when creating and restoring the backup made in phpMyAdmin?
WPBeginner Support
There should not be a specific step required for that, you may want to check with your hosting provider to ensure you are not running into a limit set by them when downloading your database.
Admin
Mrteesurez
When I used Duplicator, free version to backup my site, do I still need to backup database separately when I have done a complete backup of the files ?
Isn’t a database not included ??
WPBeginner Support
The free version includes the database so you would not need to worry about that.
Admin
Mrteesurez
Thanks for your reply, this is good, the basic version of the plugin has given more than enough by making this possible both the lite version. Now I will not need to worry about database.
Prajwal Shewatkar
Backup is the only solution to achive ultimate security. No matter how much you try someday you’ll have security issues on website and only backups can save you. I recommend daily full backup.
WPBeginner Support
It would depend on how often content is added to a site for how often backups should be ran but they are great for keeping a site safe
Admin
Jiří Vaněk
Daily backups seem unnecessary to me, and for a larger website, you’ll very quickly need a lot of storage. In my opinion, the best practice is to perform backups before any changes or upgrades, or after adding new content. Personally, I perform an automatic backup using Duplicator once a week to Google Drive and keep 4 backups at a time. This way, I have about a month covered, and even for my site, which is 1.5 GB, the backup sizes remain quite reasonable. Otherwise, I always back up the entire FTP and database.
Jiří Vaněk
I use phpMyAdmin for exporting the database. When I use a plugin, can I rely on the resulting backup being as comprehensive as using phpMyAdmin?
WPBeginner Comments
Yes, it should copy the whole WordPress database. It can actually be more comprehensive, because it can also include things like images and media.
Jiří Vaněk
Thanks a lot for the confirmation. So I will probably switch to an automated backup with the help of a plugin.
Moinuddin Waheed
I am getting stucked with the import file of the database in phpmyadmin of the local xampp server.
I wanted to make a test site for a live website, I followed the steps mentioned above but when I am importing the database file, it gives an error Maximum execution time of 300 seconds exceeded”
and it doesn’t proceed further.
is there a way I can solve this issue?
WPBeginner Support
That can happen if you are importing a large database, you would need to increase your execution time, our guide below has two methods you can use or you may need to go into your XAMPP options to change these settings if it does not work for you.
https://www.wpbeginner.com/wp-tutorials/how-to-fix-fatal-error-maximum-execution-time-exceeded-in-wordpress/
Admin
Moinuddin Waheed
Thanks for the reply.
I have sorted out this problem following this guide.
I increased the execution time limit and it worked.
so, by default the execution time is very less and it needs to be updated for importing large files.
Moinuddin Waheed
I have done manual backups many times and was unable to restore the back up database files in the liver server.
Having said this, is there any method which can ensure full back of everything like themes , settings and database all in one?
if this can be achieved, it would be very easy to restore any website without losing anything.
WPBeginner Support
We would recommend taking a look at our guide below for some of the ways to backup your files and database for what you are looking for.
https://www.wpbeginner.com/beginners-guide/how-to-backup-your-wordpress-site/
Admin
Moinuddin Waheed
Thanks for the recommendation, I have gone through the guide and found it really helpful for creating backup that can be used to restore the website when needed.
A Owadud Bhuiyan
Manually backing up the database is incredibly useful, especially when testing plugins locally.
WPBeginner Support
It can certainly be helpful
Admin
Richard
What is the difference between a database backup and a site backup performed by a plugin such as Duplicator Pro?
WPBeginner Support
It varies from plugin to plugin but normally a site backup includes the theme and plugin files while a database backup is for your content.
Admin
Rafal
I dont see any Backup Buttons on my Bluehost account: there are only tabs: Home, My sites, Marketplace, e-mail, domains, advanced
WPBeginner Support
Hi Rafal,
Click on the Advanced Tab to access the full cPanel interface.
Admin
Rose
If I have a premium or business wordpress site, then wordpress is my host, correct? What can I do from wordpress.com besides an export?
WPBeginner Support
Hi Rose,
Please see our guide on the difference between self hosted WordPress.org vs free WordPress.com blog.
Admin
tim
Hi. I have all folders from a wordpress site but i dont have any database backup. Is it possible to restore drom folders without sql backup?
WPBeginner Support
Hi Tim,
No you cannot. You can try finding the lost content by using Google Cache or Way Back Machine.
Admin
David John
I have Finished the given all the steps, but i can’t backup my site, it shown be a Sever Error…And How to Rectify this error….
Rebecca
Can you use the built in “export” feature as a manual backup?
WPBeginner Support
Not a good idea. The export file will be able to import your comments and posts into WordPress. However, it will not be able to import images if they have been removed or lost from original server. It will also be unable to restore any other data stored in WordPress database.
Admin
afdhal ilahii
my i share this at my blog?
Syed Azad Shah
Dear Syed,
Many thanks for your wonderful posts. They are really doing miracles for me. Just one question – I have four or five sites running on one hosting account. One from main directory and rest from sub-directories. How do I go about backing them up all. My website is
Should I back them up as one file or different files
Thank you very much
Azad
WPBeginner Support
Depends on your setup. If all of them are using the same database, then you can select tables for each site and then export them. Repeat for the next site.
If they are using different databases then you need to export in different files.
Admin
Teguh
And how to restore it?
WPBeginner Support
See our guide, how to restore WordPress from backup.
Admin
Ahmed LAHMAR
Hi WPBeginner,
I use WP-DBManager and i would recommend it to anyone who wants some peace of mind it’s a wonderful plugin that you can backup your database, compress it into .gz file (my 70 mb SQL file became 5 mb after compression) and email it to you as schedueled. You can choose daily and weekly backup or you can do the backup manually.
The plus other featues like optimisation which you can scheduel as well
Ahmed LAHMAR
Sorry for typing mistakes m’y keyboard went mad