Beginner’s Guide: How to Backup WordPress Database Manually

This WordPress guide teaches you how to manually backup your WordPress database without using plugins. It’s the hard way but most of the web developers prefer the manual backup. Why depend on a plugin when you know you can create a backup of your WordPress database whenever you need it.

Important: It is strongly recommended to backup your database before performing any upgrade on your Website.

Go directly to the methods we have covered in this WordPress tutorial:

Why should you backup WordPress Database?

WordPress database stores lots of stuff in the database such as all your post, pages, comments, users and other information like plugin and theme settings. You don’t wanna lose all these important stuff when something goes wrong with your site.

WordPress database backup allows you to restore all your WordPress content back to normal after an upgrade error leads to dysfunctioning of your site.

What if someone hacked your WordPress site and comprised your website content. In such situation, you won’t be able to login to your wp-admin area. To fix this, first, you need to reset your WordPress password from the database and then restore all your content using the WordPress database backup you created.

That is why you should backup your WordPress database regularly.

Read: How to Recover lost Password in WordPress

Manually Backup WordPress Database using Cpanel

This is the simplest way to create a manual backup of your WordPress database. Most web hosting providers offer control panel (Cpanel) feature to its customers.

Otherwise, you can use FTP to backup WordPress files such as themes, plugins, images, etc.

Follow the steps below to back up your MySQL database with Cpanel:

  • Log in to your hosting Cpanel account.
  • Look for the Backup option. Generally, it can found under Files section.

open-backup-from-cpanel

  • Here, you’ll find Download a MySQL Database Backup.

MySQL database backup using Cpanel

  • Click the name of the database.
  • The database backup will be downloaded to your local computer as a .gz extension.

In future, if you want to restore your database backup you can upload this .gz file using Restore a MySQL Database Backup option found in the same Cpanel window.

How to Backup WordPress Database with phpMyAdmin

Step #1: Go to your Cpanel hosting dashboard and open phpMyAdmin under database section.

open-phpmyadmin

Step #2: From the left side of the screen, click on your database name.

click-your-database-name

Step #3: It will show the list of tables present in your database. Click on Export tab at the top menu.

open-export-menu

Step #4: Select Export method to Quick and then hit Go button. Start the download and save it your computer.

select-export-method-quick

Step #5: Selecting the Custom option gives you more advanced option such as to select which table you don’t want to be included in the backup. Under Output, select Save output to a file and set compression to ‘zipped or gzipped’.

select-custom-option

Step #6: Leave other option as it is. Scroll down to the bottom and hit the Go button to begin downloading the backup.

That’s all. You have successfully created a backup of your WordPress database.

Frequently Asked Questions

Q: What is the database for WordPress?

A: Database is a set of information stored in a structured and organized manner. In WordPress, MySQL is used as a database management system (DBMS) to create a database for your website. Almost all web hosting companies offer MySQL database.

Q: How do I access my Database on WordPress?

A: To access your WordPress database, go to Cpanel > Database > phpMyAdmin. Here, you’ll find your list of databases on the left side. Click on the name of your database, it’ll show you the list of database tables.

Q: How often should I backup my WordPress database?

A: For security reason, you should backup your database regularly. Always create a backup before upgrading your themes or plugins.

If you liked this article, please share using the below social media icon. If you still have any problem with creating your WordPress database backup, comment down below.

Add a Comment

Your email address will not be published. Required fields are marked *