Home / Uncategorized / How to Backup WordPress Database Manually

How to Backup WordPress Database Manually

There are many plugins are available that can make a wordpress backup for you. With WP plugins you can schedule your database backups to daily, weekly and yearly basis without any user input. In our recent tutorial we talked about 10 Best Database Backup Plugins for WordPress that can create a complete backup of your site and send you by email. You can also send your backups to amazon, dropbox and other cloud storage sites remotely but It is also better for us to know how we can make a Backup manually if we ever need. Now i am trying to show you how to create WordPress Database Backup through cPanel manually without help of any plugin.

Make a Database Backup via MySQL

Follow the simple steps to perform a backup.

First of all login to your cPanel account and click on phpMyAdmin icon and select your WordPress Database.



When you select your following Database, simply click on “Export” button.


check on Quick – display only the minimal option and select the SQL format and finally click on Go button

In few seconds Your browser will start downloading the database backup file on your PC. Download the file and save him to your hard drive.

Make a Database Backup

First of fall login to your cPanel hosting account and then click  on “Backups” icon.


As you can see there are four type of options are available. you can download your whole website by clicking on “Home Directory” link, download emails backup, filters but we only need a database backup so we select on “MySQL tab” to download a Database backup.


We hope this article helps you to know more about wordpress. But we recommended you to use WordPress plugins for this purpose. because WP Plugins can do this job easily and can save your lot of time.



About tahir

Muhammad Tahir lives in Lahore, Pakistan. Loves to read and write articles about tech and web resources online.

Check Also

EasyPaisa ATM Card Full Details

EasyPaisa ATM Card is the best choice for those who want to get their own …

Bitcoin is Fraud and Blow Soon – Jamie Dimon Predictions

JP Morgan’s boss Jamie Dimon said that Bitcoin is a fraud sooner or later it …

Fix Mirror or Upside Down Videos Easily : How to Rotate or Flip

Sometimes we make a video through our smartphone and when we play it on our …

Bitcoin Cross the limit of 4000 Dollar

Virtual currency bitcoin recently faced Hard Fork problem because its block chain touches his limits …

Top Online Prepaid Cards Providers 2017

Credit/Debit or Prepaid Cards makes our life easier than ever whether we shop online or …