WPBeginner

Beginner's Guide for WordPress

  • Blog
    • Beginners Guide
    • News
    • Opinion
    • Showcase
    • Themes
    • Tutorials
    • WordPress Plugins
  • Start Here
    • How to Start a Blog
    • Create a Website
    • Start an Online Store
    • Best Website Builder
    • Email Marketing
    • WordPress Hosting
    • Business Name Ideas
  • Deals
    • Bluehost Coupon
    • SiteGround Coupon
    • WP Engine Coupon
    • HostGator Coupon
    • Domain.com Coupon
    • Constant Contact
    • View All Deals »
  • Glossary
  • Videos
  • Products
X
☰
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

WPBeginner» Blog» Beginners Guide» How To Make a WordPress Database Backup Manually

How To Make a WordPress Database Backup Manually

Last updated on May 6th, 2016 by Editorial Staff
313 Shares
Share
Tweet
Share
Pin
Free WordPress Video Tutorials on YouTube by WPBeginner
How To Make a WordPress Database Backup Manually

Do you want to know how to make a WordPress database backup manually without using a plugin? Knowing the manual method allows you to quickly create a database backup whenever you need it. In this article, we will show you how to make a WordPress database backup manually.

WordPress Database Backup Manually

When and Why Make a WordPress Database Backup Manually

You should always install and setup a WordPress backup system for your site. This allows you to restore your site should something go wrong.

Many users lose access to their WordPress admin area after a hack attempt or some plugin error. In these cases, most tutorials recommend that you create a complete WordPress backup.

However, since you cannot access the admin area, it would be hard for you to use a plugin for backups. This is where knowing how to make a WordPress database backup manually comes in handy.

A manual database backup is exactly the same as the database backups created by a plugin.

Having said that, let’s take a look at how to easily make a WordPress database backup manually.

Backing Up WordPress Database Manually Using phpMyAdmin

For this method we will be using PhpMyAdmin. It is an open source software that allows you to manage your MySQL database using a web based interface. It comes pre-installed on most WordPress hosting providers.

First you need to login to your WordPress hosting control panel. Upon login, click on phpMyAdmin under the database section.

phpmyadmin

This will launch phpMyAdmin window. Make sure your WordPress database is selected inside phpMyAdmin. If it isn’t, then click on your WordPress database name to select it. You will be able to see the list of WordPress database tables when it is selected.

Once your database is selected, click on Export link from the top menu bar.

phpMyAdmin Export Button

You will be asked to select the export method. You need to select custom as it will give you more options to explore.

phpMyAdmin Export Method

Clicking on custom will reveal more options. First it will show all your tables in your WordPress database as selected.

Sometimes WordPress plugins add their own tables to your database. If there are any tables that you would like to exclude from export, then you can deselect them. If you are unsure, then it is better to keep them all selected.

phpMyAdmin Custom Export

Scroll down to the output section. By default, phpMyAdmin will show you the output of the export process as text. You need to change that by selecting ‘Save output to a file’ option. For compression you need to select zipped or gzipped option.

Now you need to scroll down to the bottom of the page and click on the ‘Go’ button.

PhpMyAdmin will now send you the database export as zip or gzip file.

That’s all, you have successfully made a manually WordPress database backup.

Creating a Manual WordPress Database Backup from cPanel

Most good WordPress hosting companies also offer easier ways to download on demand backups. Here is how you can use that to make a manual WordPress database backup.

Simply login to your hosting control panel and scroll down to the files section where you will see the Backup button. Bluehost, SiteGround, and HostGator all have similar options.

On the backups page, scroll down to partial backups section and click on your database name to download your database backup file.

Download a WordPress database backup using cPanel

You can also download your WordPress files backup from this page if you need to.

Editor’s Note: You can make WordPress database backups manually, but keep in mind that it is not an alternative to a proper backup solution for your WordPress site.

There are situations when you may not have access to your WordPress database at all. Like if your hosting company suspends your account, or loses your data.

Another possible scenario is when some hacker has injected data in your WordPress database, cleaning an infected database would be a lot more difficult.

Use a proper backup plugin to automatically store your WordPress database backups on the cloud. We recommend using BackupBuddy, it automatically creates and stores your backups on a cloud storage service like Google Drive, DropBox, or Stash.

See our guide on how to keep your WordPress content safe with BackupBuddy for detailed instructions.

That’s all, we hope this article helped you learn how to make a WordPress database backup manually. You may also want to see our guide on how to restore your WordPress site with just a database backup.

If you liked this article, then please subscribe to our YouTube Channel for WordPress video tutorials. You can also find us on Twitter and Facebook.

313 Shares
Share
Tweet
Share
Pin
Popular on WPBeginner Right Now!
  • Google Analytics in WordPress

    How to Install Google Analytics in WordPress for Beginners

  • How to Fix the Error Establishing a Database Connection in WordPress

    How to Fix the Error Establishing a Database Connection in WordPress

  • Revealed: Why Building an Email List is so Important Today (6 Reasons)

    Revealed: Why Building an Email List is so Important Today (6 Reasons)

  • How to Start Your Own Podcast (Step by Step)

    How to Start Your Own Podcast (Step by Step)

About the Editorial Staff

Editorial Staff at WPBeginner is a team of WordPress experts led by Syed Balkhi. Trusted by over 1.3 million readers worldwide.

The Ultimate WordPress Toolkit

18 Comments

Leave a Reply
  1. Richard says:
    Jul 2, 2019 at 1:24 pm

    What is the difference between a database backup and a site backup performed by a plugin such as Duplicator Pro?

    Reply
    • WPBeginner Support says:
      Jul 3, 2019 at 11:03 am

      It varies from plugin to plugin but normally a site backup includes the theme and plugin files while a database backup is for your content.

      Reply
  2. Rafal says:
    Jun 21, 2018 at 6:51 pm

    I dont see any Backup Buttons on my Bluehost account: there are only tabs: Home, My sites, Marketplace, e-mail, domains, advanced

    Reply
    • WPBeginner Support says:
      Jun 21, 2018 at 8:28 pm

      Hi Rafal,

      Click on the Advanced Tab to access the full cPanel interface.

      Reply
  3. Rose says:
    Apr 25, 2018 at 1:39 am

    If I have a premium or business wordpress site, then wordpress is my host, correct? What can I do from wordpress.com besides an export?

    Reply
    • WPBeginner Support says:
      Apr 25, 2018 at 7:20 pm

      Hi Rose,

      Please see our guide on the difference between self hosted WordPress.org vs free WordPress.com blog.

      Reply
  4. tim says:
    Sep 25, 2017 at 8:18 am

    Hi. I have all folders from a wordpress site but i dont have any database backup. Is it possible to restore drom folders without sql backup?

    Reply
    • WPBeginner Support says:
      Sep 26, 2017 at 8:04 am

      Hi Tim,

      No you cannot. You can try finding the lost content by using Google Cache or Way Back Machine.

      Reply
  5. David John says:
    Dec 21, 2016 at 5:16 am

    I have Finished the given all the steps, but i can’t backup my site, it shown be a Sever Error…And How to Rectify this error….

    Reply
  6. Rebecca says:
    Sep 5, 2016 at 9:49 am

    Can you use the built in “export” feature as a manual backup?

    Reply
    • WPBeginner Support says:
      Sep 5, 2016 at 11:09 am

      Not a good idea. The export file will be able to import your comments and posts into WordPress. However, it will not be able to import images if they have been removed or lost from original server. It will also be unable to restore any other data stored in WordPress database.

      Reply
  7. afdhal ilahii says:
    Aug 15, 2016 at 2:17 am

    my i share this at my blog?

    Reply
  8. Syed Azad Shah says:
    May 10, 2016 at 9:11 am

    Dear Syed,
    Many thanks for your wonderful posts. They are really doing miracles for me. Just one question – I have four or five sites running on one hosting account. One from main directory and rest from sub-directories. How do I go about backing them up all. My website is
    Should I back them up as one file or different files

    Thank you very much
    Azad

    Reply
    • WPBeginner Support says:
      May 11, 2016 at 10:59 pm

      Depends on your setup. If all of them are using the same database, then you can select tables for each site and then export them. Repeat for the next site.

      If they are using different databases then you need to export in different files.

      Reply
  9. Teguh says:
    May 9, 2016 at 10:44 pm

    And how to restore it?

    Reply
    • WPBeginner Support says:
      May 11, 2016 at 11:14 pm

      See our guide, how to restore WordPress from backup.

      Reply
  10. Ahmed LAHMAR says:
    May 6, 2016 at 2:47 pm

    Hi WPBeginner,
    I use WP-DBManager and i would recommend it to anyone who wants some peace of mind it’s a wonderful plugin that you can backup your database, compress it into .gz file (my 70 mb SQL file became 5 mb after compression) and email it to you as schedueled. You can choose daily and weekly backup or you can do the backup manually.

    The plus other featues like optimisation which you can scheduel as well

    Reply
    • Ahmed LAHMAR says:
      May 6, 2016 at 2:50 pm

      Sorry for typing mistakes m’y keyboard went mad

      Reply

Leave a Reply Cancel reply

Thanks for choosing to leave a comment. Please keep in mind that all comments are moderated according to our comment policy, and your email address will NOT be published. Please Do NOT use keywords in the name field. Let's have a personal and meaningful conversation.

Over 1,320,000+ Readers

Get fresh content from WPBeginner

Featured WordPress Plugin
OptinMonster
OptinMonster
Convert website visitors into email subscribers. Learn More »
How to Start a Blog How to Start a Blog
I need help with ...
Starting a
Blog
WordPress
Performance
WordPress
Security
WordPress
SEO
WordPress
Errors
Building an
Online Store
Useful WordPress Guides
    • 7 Best WordPress Backup Plugins Compared (Pros and Cons)
    • How to Fix the Error Establishing a Database Connection in WordPress
    • Why You Need a CDN for your WordPress Blog? [Infographic]
    • 30 Legit Ways to Make Money Online Blogging with WordPress
    • Self Hosted WordPress.org vs. Free WordPress.com [Infograph]
    • Free Recording: WordPress Workshop for Beginners
    • 24 Must Have WordPress Plugins for Business Websites
    • How to Properly Move Your Blog from WordPress.com to WordPress.org
    • 5 Best Contact Form Plugins for WordPress Compared
    • Which is the Best WordPress Popup Plugin? (Comparison)
    • Best WooCommerce Hosting in 2021 (Comparison)
    • How to Fix the Internal Server Error in WordPress
    • How to Install WordPress - Complete WordPress Installation Tutorial
    • Why You Should Start Building an Email List Right Away
    • How to Properly Move WordPress to a New Domain Without Losing SEO
    • How to Choose the Best WordPress Hosting for Your Website
    • How to Choose the Best Blogging Platform (Comparison)
    • WordPress Tutorials - 200+ Step by Step WordPress Tutorials
    • 5 Best WordPress Ecommerce Plugins Compared
    • 5 Best WordPress Membership Plugins (Compared)
    • 7 Best Email Marketing Services for Small Business (2021)
    • How to Choose the Best Domain Registrar (Compared)
    • The Truth About Shared WordPress Web Hosting
    • When Do You Really Need Managed WordPress Hosting?
    • 5 Best Drag and Drop WordPress Page Builders Compared
    • How to Switch from Blogger to WordPress without Losing Google Rankings
    • How to Properly Switch From Wix to WordPress (Step by Step)
    • How to Properly Move from Weebly to WordPress (Step by Step)
    • Do You Really Need a VPS? Best WordPress VPS Hosting Compared
    • How to Properly Move from Squarespace to WordPress
    • How to Register a Domain Name (+ tip to get it for FREE)
    • HostGator Review - An Honest Look at Speed & Uptime (2021)
    • SiteGround Reviews from 4464 Users & Our Experts (2021)
    • Bluehost Review from Real Users + Performance Stats (2021)
    • How Much Does It Really Cost to Build a WordPress Website?
    • How to Create an Email Newsletter the RIGHT WAY (Step by Step)
    • Free Business Name Generator (A.I Powered)
    • How to Create a Free Business Email Address in 5 Minutes (Step by Step)
    • How to Install Google Analytics in WordPress for Beginners
    • How to Move WordPress to a New Host or Server With No Downtime
    • Why is WordPress Free? What are the Costs? What is the Catch?
    • How to Make a Website in 2021 – Step by Step Guide
Deals & Coupons (view all)
LiveChat logo
LiveChat Inc Coupon
Get a 30 day free trial and 30% OFF LiveChat, one of the best live chat service providers for WordPress users.
LearnDash
LearnDash Coupon
Get the lowest price on the best learning management system (LMS) plugin for WordPress.
Featured In
About WPBeginner®

WPBeginner is a free WordPress resource site for Beginners. WPBeginner was founded in July 2009 by Syed Balkhi. The main goal of this site is to provide quality tips, tricks, hacks, and other WordPress resources that allows WordPress beginners to improve their site(s).

Join our team: We are Hiring!

Site Links
  • About Us
  • Contact Us
  • FTC Disclosure
  • Privacy Policy
  • Terms of Service
  • Free Blog Setup
  • Free Business Tools
  • Growth Fund
Our Sites
  • OptinMonster
  • MonsterInsights
  • WPForms
  • SeedProd
  • Nameboy
  • RafflePress
  • Smash Balloon
  • AIOSEO

Copyright © 2009 - 2021 WPBeginner LLC. All Rights Reserved. WPBeginner® is a registered trademark.

Managed by Awesome Motive | WordPress hosting by SiteGround | WordPress Security by Sucuri.