What's WP
Find Everything Related to WordPress - Best Tutoriasl on WordPress!
How To Backup and Restore Your Database in cPanel?

How To Backup and Restore Your Database in cPanel?

backup datebase in cpanelBacking up the database is an important step to keep the websites security. There are many different approaches to back up database with ease, but if you’re using a Linux-based web hosting service with control panel cPanel, that makes things easy. In below, we introduce the steps of using cPanel to backup your database.

The database is essential to keep the website online and running well if you have a database driven website. Today, attacks and hacks happened every day, and the number of security issues is increasing dramatically. So it’s extremely important to backup your website regularly, especially with the following reasons.

  • Sometimes, some quality web hosts like BlueHost, InMotion Hosting, and HostGator back up the server scheduly, but they may not run their backups as often as you would require your site to be backed up, so you should not set a good expectation on the web hosts.
  • If you website is hacked unfortunately, you can restore it from the most recent secure backup. If you haven’t backed up your site already, you have to weasel out every little bit of infected code.
  • You always need to upgrade the website script and plugins up-to-date for some reasons such as security, features, etc. Remember back up your site before upgrading, because any small mistake or incompatibility may cause your website down or damaged. However, it’s simple to restore the site if you have a backup.

Backup MySQL Database with cPanel

All these reasons show that it’s important to backup database regularly. Indeed, it’s easy to backup through cPanel because cPanel is powerful to help you manage your hosting account and websites. In below, we introduce the steps carefully, with which you can back up your site within minutes.

  1. Log into your cPanel account. In general, the address is http://yourdomain.com/cpanel.
  2. Scroll down to Files, click on Backups.

    click on Backups

  3. You will be linked to Download a MySQL Database Backup section. Click on your database name under the Partial Backups, in this case it is userna5_wordpress. As you see, you can even do a full backup, which includes all the files in your home directory, your MySQL database, and your email forwarders and filters.
  4. Download a MySQL Database Backup

  5. Download the file and save it in your local computer. You can see a compressed .sqp.gz file.
  6. compressed backup file

Now, you have successfully backup your database and locally stored the file on your own computer. If your database has something problems or you delete something by accident, you can quickly restore it from the backup.

Restore MySQL Database with cPanel

Restoring MySQL database to a previous backup state is a great way to get the website working well. As well, the process is quite easy, just a reverse process of the backup.

  1. Log into your cPanel account.
  2. Scroll down to the File, and click on the Backups.
  3. Under restore a MySQL Database, click on Choose File. You will be taken to browse your database backup, find and select it, click Open and then click Upload at last.
  4. restore a MySQL Database

  5. It will take some time to restore. Finally, you can see the backup has been restored. In this process, it reminds the userna5_wordpress database already exists.
  6. restored a MySQL Database


Joyce is a professional writer & SEOer who loves trying new things and sharing the experience through blogging. She loves clean design, playing with different WordPress themes, SEO, etc. Very often, you could find her in various WordPress event as invited speakers.