How to Backup and Restore MySQL from cPanel

MySQL is one of the most popular relational database management software applications. It is used by millions of webmasters to run dynamic websites. Also, most Content Management systems rely on MySQL to store information (e.g. WordPress and OpenCart).

A database backup is very essential in a production environment whether it’s a software or a website. Luckily if your web host supports cPanel, you can create and restore MySQL backups directly from it and this forms the basis of this guide.

Prerequisites

  • A domain name e.g. www.example.com
  • A web hosting account that supports cPanel
  • cPanel username and password.

Special note: consult HostAdvice’s best MySQL hosting page to find the leading web hosts in this category, including expert as well as user reviews.

Step 1: Log to your cPanel Account

Visit your cPanel account from your browser by entering the below text on your browser:

http://www.example.com/cpanel

Remember to replace ‘example.com’ with the primary domain associated with your cPanel account. You browser will then display the below login page. Enter your username and password to proceed:

Step 2: Search the Backup Feature

Next, you need to search the backup feature by typing the word ‘Backup’ on the search box. Then click on the backup icon to proceed as shown below:

Step 3: Locate your database under the list of databases

Next, you will need to locate your database under a list of databases on the next screen. You will find this slightly above the bottom of the screen. Just click the database that you want to backup as shown below:

You will be prompted to save your database on your computer. You can edit the name of the file or leave it intact as shown below:

Step 4: Restoring the database

To restore your MySQL database, find the title, ‘Restore a MySQL Database Backup’ under ‘Account Backups’, then click ‘Choose File’ and ‘Upload’ as shown below

Your database will be successfully restored if there were no errors:

Conclusion

That’s when it comes to creating and restoring MySQL database backups. To be on the safe side, you can append, the date and time when you save a MySQL backup file so that you can easily identify your backups chronologically from your computer (e.g. you can have a file name like ‘2018-05-29-19-59-HRS_test_database.sql’).

Also, MySQL databases backups should be kept securely because somebody can upload them to a server to read their contents. Also, It is always advisable to keep an off-site backup of your website and the cPanel MySQL backup feature makes this possible.

If you have followed the guide from the beginning, backing up your website/application database will easy and fast. I hope this was a resourceful article worth reading.

 

Check out the top 3 cPanel hosting services:

HostArmada
$2.49 /mo
Starting price
Visit HostArmada
Rating based on expert review
  • User Friendly
    4.5
  • Support
    4.5
  • Features
    4.5
  • Reliability
    4.5
  • Pricing
    4.0
IONOS
$1.00 /mo
Starting price
Visit IONOS
Rating based on expert review
  • User Friendly
    4.5
  • Support
    4.0
  • Features
    4.5
  • Reliability
    4.5
  • Pricing
    4.3
Ultahost
$2.90 /mo
Starting price
Visit Ultahost
Rating based on expert review
  • User Friendly
    4.3
  • Support
    4.8
  • Features
    4.5
  • Reliability
    4.0
  • Pricing
    4.8

How to Manage MySQL Databases and Users on cPanel

This tutorial describes how to manage MySQL databases and database users using t
2 min read
Max Ostryzhko
Max Ostryzhko
Senior Web Developer, HostAdvice CTO

How to Optimize Queries in your MySQL and MariaDB Databases

In this guide, we cover what a database administrator can do to optimize databa
3 min read
Michael Levanduski
Michael Levanduski
Expert Hosting Writer & Tester

How to Move Your WordPress Site from Your Local Web Server to Your Live Site

You can always accelerate the development process by developing your WordPress s
4 min read
Max Ostryzhko
Max Ostryzhko
Senior Web Developer, HostAdvice CTO

How to Disable MySQL 5 "Strict Mode" on an Ubuntu 18.04 VPS or Dedicated Server

How to Disable MySQL Strict Mode on MySQL 5.6 Running on an Ubuntu 18.04 VPS.
2 min read
Idan Cohen
Idan Cohen
Marketing Expert
HostAdvice.com provides professional web hosting reviews fully independent of any other entity. Our reviews are unbiased, honest, and apply the same evaluation standards to all those reviewed. While monetary compensation is received from a few of the companies listed on this site, compensation of services and products have no influence on the direction or conclusions of our reviews. Nor does the compensation influence our rankings for certain host companies. This compensation covers account purchasing costs, testing costs and royalties paid to reviewers.
Click to go to the top of the page
Go To Top