Knowledge Base
How do I restore a database using PHPMyadmin?
From your cPanel account login to phpMyAdmin section and follow the below steps to restore database.
![](https://kb.dollar2host.com/wp-content/uploads/2023/06/image-627.png)
Select the database name from the left handside of window.
![](https://kb.dollar2host.com/wp-content/uploads/2023/06/image-628.png)
Click on ‘Import’ option located at top of window.
![](https://kb.dollar2host.com/wp-content/uploads/2023/06/image-629.png)
Under ‘File To Import’ section, click on ‘Choose File’ and select the backup file from your computer you wish to restore.
![](https://kb.dollar2host.com/wp-content/uploads/2023/06/image-630.png)
![](https://kb.dollar2host.com/wp-content/uploads/2023/06/image-631.png)
From the drop-down menu of ‘Format’ select ‘SQL’ option.
![](https://kb.dollar2host.com/wp-content/uploads/2023/06/image-632.png)
Click on the ‘Import’ button.
![](https://kb.dollar2host.com/wp-content/uploads/2023/06/image-633.png)
After clicking on ‘Import’ option the database will be restored from the backup file selected.