How to restore a Joomla database using cPanel

You will need to log into cPanel with your supplied username and password. Normally this URL is: http://www.yourdomain.com/cpanel

1) Select the Username field and enter your username
Joomla Content Management System

2) Select the Password field and enter your password
Joomla Hosting

3) Next click the Log in button
Joomla CMS

4) Select the Backups icon in the Files section
Joomla Cloud

We’ll assume that the database to be restored does not exist and will be created via this process

5) Scroll down so you can click on the Browse button for Restore a MySQL Database
Joomla Web Hosting

6) Select the file that was previously created using cPanel Backup
Joomla Cloud Hosting

7) Now click the Open button
Joomla Content Management System

8) Next click the Upload button
Joomla Hosting

9) Once the restore has been completed, scroll up and click on the cPanel Home icon
Joomla CMS

10) Scroll down and click on the MySQL Databases icon in the Databases section
Joomla Cloud

Scroll down and note that no Users are assigned to the restored database
Joomla Web Hosting

11) Scroll down further and select the User dropdown list under Add User to Database
Joomla Cloud Hosting

12) Let’s select the previous user assigned to this database
Joomla Content Management System

13) Next select the restored database from the Database dropdown list
Joomla Hosting

14) Now click the Add button
Joomla CMS

15) Check the ALL PRIVILEGES checkbox
Joomla Cloud

16) Scroll down and click the Make Changes button
 Joomla Web Hosting

17) Click the Go Back button
Joomla Cloud Hosting

Scroll down to see that a user has been assigned to our restored database
Joomla Content Management System

You now now how to restore a Joomla database using cPanel