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
Elegant Themes
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 »


  1. 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?

  2. Pia says:

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

  3. Viola Woolcott says:

    I just LOVE wordpress ;-)

  4. 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.

  5. 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]

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.