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:
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.
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!