How To Make a WordPress Database Backup Manually

Most bloggers are not tech savvy when they first start out. If you used our WordPress guide and selected the recommended WordPress plug-in then you already have a plug-in that is called WordPress Database Backup which does this job for you automatically. But it is always good to know how you can make a Database Backup manually if you ever needed. Therefore we will show you how you can make a WordPress Database Backup through MySQL and through cPanel manually without relying on the plugin.

Make a Database Backup via MySQL

Follow the steps below:

1. Login to phpMyAdmin and select your WordPress Database.
2. Once you have selected the Database, click the tab called “Export”.
3. Choose a method of compression method (preferred gzip), and click the Execute button
4. You will see a message in your browser that will ask you to Download this file, click Yes and you will have a backup to your Database now.

Pretty simple and easy. Now the second method is via cPanel. Note you must have a cPanel Web Host in order to do it with this method.

cPanel Backup Method

First you need to login to your cPanel and then click “Backups”. Scroll down to where it says Download a MySQL Database Backup. Click on the database that you want to backup and download the backup.

These methods above are just something that you should know how to do. But the plugin WordPress Database Backup makes this job much easier. We strongly recommend you have this installed, so you can have regular backups.