Beginner's Guide for WordPress - Start your WordPress Blog in minutes.
Choosing the Best
WordPress Hosting
How to Easily
Install WordPress
Recommended
WordPress Plugins
View all Guides

How To Make a WordPress Database Backup Manually

Last updated on by
Follow WPBeginner on YouTube
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

MySQL Backup

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

cPanel Backup

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.


Editorial Staff at WPBeginner is a team of WordPress lovers led by Syed Balkhi. Page maintained by Syed Balkhi.

WPBeginner's Video Icon
Our HD-Quality tutorial videos for WordPress Beginners will teach you how to use WordPress to create and manage your own website in about an hour. Get started now »
  • http://www.wpbeginner.com/ WPBeginner Staff

    Yes cPanel backups usually contain every thing. However, just to be sure you can unzip a backup file to make sure it has everything or ask your hosting provider.

    Saving backup on your computer is not a great idea. If your computer gets affected by a malware, then it could corrupt your backup as well. Saving it on an external media is a good approach. But we would recommend you to store your backups on the cloud, like Dropbox, Google drive, etc.

  • zimbrul

    This must be a stupid question but how do you use database to restore a let’s say hacked WordPress site? You need to have the rest of the files, don’t you? Having just the database I don’t think will allow you to restore the site, am I right?

  • Pia

    That’s easy enough, but could you just add a quick ‘Restore’ post as well?

  • http://www.dare2baware.com Viola Woolcott

    I just LOVE wordpress ;-)

  • http://www.pricespakistan.com Aneeza Mubbashir

    I am utterly amazed at how simple you made this for me. Thank you for your hard work as this plug-in is a most for anyone who understands that information can be easily lost.

  • Andy Brudtkuhl

    As tedious and crappy as manual WP database backup is we prefer to use either WP-DB-Backup which automatically backs up your database and emails it to you. Or you can use our plugin that automatgically backs up both your WP files and database to your amazon s3 account… much easier :)

    [Link Removed, We do not allow Sales Page Links]