How to take WordPress Database Backup Manually: 2 Different Methods

If you are WordPress user, then you definitely know the importance of keeping the backup of your WordPress website. Because WordPress database contains important things like posts, comments, links, plugins settings, theme settings, user accounts and many other important things. So, there is always a risk of losing those essential data of your site.

It is important that you create a backup of you WordPress database. WordPress offers one of the best protections against any sort of security problem for your site. So, if you wish to take backup of your WordPress Database then there are 2 different methods you can use, which are easy and quickly as well.

But before you jump to create a manual backup of your WordPress database, let first understand, when you should have to create a manual backup, and what are the benefits of creating the manual backup.

2 Difference Method to Create WordPress Database Backup Manually

2 different methods of How to take WordPress Database Backup ManuallyCreating a backup of your WordPress database allows you to get all those valuable data you want from your website. So it is also very important that you regularly install and setup the backup of your WordPress database. Because such backups help you to recover, if something goes wrong with your site like hack attempt, server crash, or plugin errors.

With these kinds of errors, there is an always risk of losing posts, comments, or even you can lose access to the admin area of your website. So, if you can’t reach to the admin area of your website, then you cannot create a backup using any plugin installed on your WordPress website.

At this point, there is only a way remains to create a backup of your WordPress Database and that is a manual method. So let’s see 2 different and easy methods with which can take a manual backup of WordPress database.

#Method 1: Creating Database Backup Accessing phpMyAdmin
Wordpress uses MySQL to manage it’s website database. So you can create a backup of your WordPress website database using this handy tool “phpMyAdmin”, which is an open source software. Using phpMyAdmin, it is very straightforward and easy method to create a backup of your WordPress database.

To back up your WordPress database, you need to login first to your WordPress hosting control panel. Once you logged into hosting control panel are, find the database option. Under / inside database option, you’ll see the phpMyAdmin icon, click on it.

After clicking on this option, it will take you to the main page of phpMyAdmin. Now, select your WordPress database on the left-hand side.

Select WordPress Databse in phpMyAdmin

Then select export tab which is located on top menu bar there will be Expert link located.
select export tab in phpMyAdmin and move to the next step

There are two checkboxes one is Quick, and another one is Custom. By default, a quick check box is selected, which will take complete database backup.

phpMyAdmin quick SQL Database Backup

With the custom option, you can select the individual table to take backup from MySQL database.

phpMyAdmin custom SQL Database Backup

Suggestion to select “SQL” format to backup of a database.

Click on the go button and it will start exporting and downloading your website database.

select SQL format to backup of a database

#Method 2: Manual Backup Using cPanel
This is the easiest way to create a backup of your WordPress database manually. Most of the WordPress hosting companies offers this features to download and take a complete backup of your WordPress database.

To do the same, login to your WordPress hosting control panel and find the option to take backup. By clicking on that option, this will navigate you to the page from where you can take a complete backup of your website database.

You can also download the full backup of your WordPress files like images, themes, plugins and more from the same page. (Depends on the hosting plan and its well-matched features.)

Note: You can take WordPress database backups manually with above mentioned methods. There are a couple of solutions for a proper database backup with automated plugins. With which you can schedule to take a backup, and it will automatically store your backups on a cloud space like Dropbox, Google Drive and more.

Read: The Most Useful WordPress Backup Plugins For Automated Backup

Pro Tip: Creating backup is not enough you should also store that backup on your server and also in your computer.

So guys give it a try for creating a manual backup and tell us below how it worked out for you. We love to hear about your experience with creating a manual backup.

Stay tuned for more of such updates on Facebook, Twitter and Google Plus.