How to Manually Backup WordPress Website Database

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.

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 change your password from phpMyAdmin and then restore all your content using the WordPress database backup you created.

That is the reason you should create a database backup regularly.

Read: Reset WordPress password using E-mail

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.

However, 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.

WordPress backup

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

Download backup from 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.

phpMyAdmin database backup

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

WordPress database

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

export database

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

export WordPress database table

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

backup WordPress database manually

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.

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.