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

How To Make a WordPress Database Backup Manually

Last updated on by
Special WordPress Hosting offer for WPBeginner Readers
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 experts 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 »


  1. WPBeginner Staff says:

    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.

  2. Libby at says:

    I do a full cpanel backup weekly and pick whatever date is the most recent, regardless if it is called a daily, weekly or monthly by Bluehost (as I understand it these dates are arbitrarily called daily, weekly etc but cumulative so irrelevant ) . Anyway, does the full cpanel backup contain everything I could ever need in the case of loosing the entire website somehow? Is picking the most recent date the best thing to do? Many thanks, Libby. P.S. I keep a copy on my Mac and a USB stick.

  3. zimbrul says:

    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?

  4. Pia says:

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

  5. Viola Woolcott says:

    I just LOVE wordpress ;-)

  6. Aneeza Mubbashir says:

    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.

  7. Andy Brudtkuhl says:

    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]

    • Kay Collier says:

      WordPress could not upload this backup plugin…I must have done something wrong…have no idea what.

      Thank you so much again for all you wonderful help and articles…love them.



Add a Comment

We're glad you have chosen to leave a comment. Please keep in mind that all comments are moderated according to our comment policy, and all links are nofollow. Do NOT use keywords in the name field. Let's have a personal and meaningful conversation.