How do I restore MySQL databases from cPanel?

For [Cloud] and [Dedicated] server customers, MySQL databases can be restored from your hosting control panel quickly and easily.

 

Note that if you require a MySQL dump file of a database, rather than a direct restore, please contact support, as these cannot be obtained from cPanel.

 

If you're on a [shared/reseller hosting plan], please contact support for database restores.

 

Take a look at our website for [more information about our backups]. Alternatively, [read our blog post] which discusses our backup policy and how you can do your own testing of your backups.


 

 

Step 1

To restore files from cPanel you can use the "R1Soft Restore Backups" plugin found in your control panel under "Files":

 

 

Note: If you are logged in as a reseller or root user, the R1soft link may not work. Please login directly to cPanel using the account username and password.


 

Step 2

Once you click the link you'll be taken to the backup server and presented with a list of recovery points, by date:

 

https://www.sharpstack.co.uk/portal/kb/restore1.png

 

To restore MySQL databases, click the second icon from the left:

 

 

You'll be taken to a list of all the databases associated with your account. Simply tick the box for the database you wish to restore. Note that it is not possible to restore individual tables, only a full database.

 

https://www.sharpstack.co.uk/portal/kb/restore3.png


 

Step 3

Once this is done, click "Restore selected" and follow the on-screen wizard.


 

Please note: If you need assistance restoring files as well as databases, please see our other article here - How do I restore files from cPanel? - Knowledgebase - Prostack


 

Need further assistance?

If you require further assistance please contact the ProStack team and we can help get this resolved for you! Get in touch today!


 
 
        
  • 12 Users Found This Useful
Was this answer helpful?

Related Articles

How often do you take backups?

By default, our software takes one daily backup of your sites/server. These backups are saved...

How do I restore files from cPanel?

For [Cloud] and [Dedicated] server customers, backup restoration can be done quickly and easily...

How do I take my own backups of my website?

In addition to the [backups we provide], we recommend customers take their own backups of their...