Backup WordPress Database using phpMyAdmin

The database is the most valuable part of your website. This contains all information that will change most often. Luckily, backing up your WordPress database is pretty straight forward and can be done using a handy tool called phpMyAdmin, which is usually available through your cPanel.

Let’s dive into the steps:

1.   Log in to your cPanel and click the phpMyAdmin icon in the Databases section.

2.   In phpMyAdmin you will see a list of database names in the left column of the home page. Simply click on the database that you wish to back up and select the Export tab at the top of the screen.

Backup WordPress database manually using phpMyAdmin

4.   Make sure the export method is “Quick” and the format is “SQL”.

Backup WordPress database manually using phpMyAdmin

5.   Click Go button. This will download a .sql file to your computer.

The download process can usually take from a few seconds to a few minutes, depending on how large your database is. The downloaded SQL file can be used to import at anytime when you need to restore or migrate your site.

Alternatively, if you’re not comfortable with the steps, or familiar with phpMyadmin, you could also backup your database within your WordPress admin panel. To do this,

  • Head to WordPress dashboard» Tools » Export » All content and click download export file. This will download a XML file to your computer. This file contains your posts, pages, comments, custom post types, categories, tags, and users.
  • 8 Users Found This Useful
Was this answer helpful?

Related Articles

Creating Default Email or Catch-All Email Address

To access the auto responders menu, click on the Default Address icon on the main screen of your...

How to Create a Backup Using FTP

Backing up your website is a necessary step for all users. The process is quite easy, and in...

Publishing Your Site Using Dreamweaver in cPanel

You can use Adobe Dreamweaver to design your website, then publish it to your hosting account....

Advanced DNS Zone Editor

Overview DNS (Domain Name Service) is the component of the Internet that converts...

Simple DNS Zone Editor

Overview DNS (Domain Name System) is the component of the Internet that converts...