Thursday , November 15 2018
Home / Technology / How to Manually Backup WordPress Database using PhpMyAdmin

How to Manually Backup WordPress Database using PhpMyAdmin

Spread the love
  • 3
    Shares

WordPress comprises two parts- files and database. WordPress core, plugins, themes, and uploads are saved as files. On the other hand, posts, comments, settings and users are stored as database. This article is a guide of how to manually backup WordPress database using phpMyAdminManually Backup WordPress Database

Why backup your WordPress Database?

WordPress database stores your posts, pages, users and other information. In short, all the content you put up on the site. Without backing up the database you’ll lose all the content and users’ information  of your site. When it is time to restore all you’ll have is WordPress files with plugins and themes but no content.

How to Backup your WordPress Database?

Most web hosts have phpMyAdmin installed in their cPanel, so manually backing up your WordPress database is a simple 5-step process to download and backup the database on your entire site. In case you want to download specific files only, then you might have to go through a couple of more steps.

Steps to make WordPress database backup

Step 1:

Access phpMyAdmin through your cPanel dashboard. At this point, you’ll need to have your FTP details, username and password for the SQL database. Input the the username and password which was used to save your SQL database.

 

phpmyadmin

Step 2:

Clicking on WordPress (or whatever is the name of the database you wish to backup) in the left hand column on your screen must reveal the tables.

 

Databse

Step 3:

Click on Export among the tabs on the top of your screen. This must reveal two simple options- Quick Custom.

 

Quick and Cutom backup

 

Choosing the Quick option would mean making the default choice to backup your entire database.

ALSO READ:5-killer-online-journal-tools-that-make-journaling-easier-and-more-fun

If this is not what you want to do and you want to backup specific tables, then you pick the Custom option. Here is where the options kick in. Having completed Step 2 you must now see a list of tables. You can select the specific ones you want to download and backup.

 

Export Database

 

Step 4:

Choosing the file format of the database backup. You can do this, regardless of which option you pick in Step 3. Data is available in different file formats. You can choose the default option- SQL or pick any of the other formats in which to save your WordPress database. Click on GO and you are done.

 

SQL Backup

 

The download itself may take a few minutes depending on the size of your site. Remember, WordPress database backup covers only covers comments and users and so on. It is not a full backup of your WordPress site.

You Like This:5-best-seo-wordpress-plugins-to-improve-search-ranking

Final Word:

That’s all, we hope this article helped you learn how to make a WordPress database backup manually

Check This:How-to-eat-healthy-on-a-budget-the-definitive-guide

Check Also

Upgrade your smart watch with the latest firmware.

Spread the love All right. Well, take care yourself. I guess that’s what you’re best, …

Leave a Reply

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