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.

phpmyadmin-in-cpanel-account111

 

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.

Comments

comments

About tahir

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

Check Also

Top Ten Lord Castle Ranking – Clash of Kings – Updated 14 July 2017

In previous post i shared Kingdom 6 Top Ten Lord Power Ranking List  Here is the ...

Top Ten Lord Kill Ranking – Clash of Kings – Updated 11 July 2017

In previous post i shared Kingdom 6 Top Ten Lord Power Ranking List  Here is the ...

Kingdom 6 Top Ten Lord Power Ranking – Clash of Kings

There are 100 of kingdoms out there in Clash of Kings game, which is available ...

MCB Lite Visa Debit Card Review

MCB Lite Visa Debit Card is a best solution for those who want to shop ...

UBL Wiz Internet Visa Card – Buy Any Thing Online

UBL Wiz is the 1st internet Prepaid Visa Debit Card which was launch in Pakistan ...