Web Hosting

Please find below our list of Web Hosting guides to help with your hosting account.

JetBackup - Restore MySQL Database

This article was posted in: Web Hosting

Video Guide


Text Guide

In this guide will be explaining how to restore a MySQL database using JetBackup.

Pre-Requisitive

We start this guide already signed into cPanel. If you do not know how to sign into cPanel then your access information will have been provided to you in your welcome email or alternatively, you can sign in via the client area. If you’re one of our resellers, you can may sign into cPanel for one of your accounts using Web Host Manager.

Step One - Backup the database in its current condition

The first thing we are going to do is create a backup of the database we wish to restore. We do this just in case we need to restore the database back to its present state should the restore fail. To create and download a backup of the database, follow these steps:

  1. Click Backup under the Files section of cPanel.
  2. Find the backup you wish to download a copy of under the Download a MySQL Database Backup.
  3. Click on the database name.
  4. A backup will then download to your computer and depending on the size of the database this may take some time.

Important Note
It is recommended you do not proceed any further with this guide until the download has completed. Once the download has finished go ahead and click the logo at the top of cPanel to return to the front screen.

Step Two - Restore the database 

We will now restore the database using JetBackup. Return to the cPanel homepage by clicking the logo at the top of the screen.

From here click on the Database Backups icon underneath the JetBackup category.

The subsequent screen will display a list of all of the database backups that exist for your account. The list is typically show in Ascending order meaning your oldest backups will appear first in the list. If you want to flip this to show your latest backups first then click on the Creation Date  heading to change the sort order.

Next, locate the database you wish to restore and the suitable date/time combination and click on Restore link under the actions column to commence the restore process. You must then confirm the prompt to add your restore request to the queue. To check on the status of your restore, click the in progress link. You'll find this exactly where the Restore link once you just clicked Restore on.

You'll then be taken to the JetBackup queue for your account. The server will queue your task along with any others running on the server at that time. Note that restores are not instantaneous and the larger the size of the backup, the longer the restore time expected. Once your backup completes it will show as “Completed” under the status column. Your data will then be as it was as at the time of the backup selected.