How to Import/Restore Your MYSQL Database Using phpMyAdmin
Login to cPanel and select PHPMyAdmin
![](https://storage.crisp.chat/users/helpdesk/website/0e35a1b5-ce97-4d12-a27e-1bbafd0ae641/13f1de77-1a19-4c1a-b96e-8b4e90ffbdcc.png)
Select the database which you wish to restore to the drop down database menu at the left. In this example, I'm selecting the database "joshipro_wptest1"
![](https://storage.crisp.chat/users/helpdesk/website/0e35a1b5-ce97-4d12-a27e-1bbafd0ae641/ee3a586e-ea58-49c5-a084-2a847e0e1f83.png)
The phpMyAdmin script that restores your database does not drop the tables first. Click the Check All / Check tables having overhead check box.
Click the With selected: drop down menu and choose Drop.
![](https://storage.crisp.chat/users/helpdesk/website/0e35a1b5-ce97-4d12-a27e-1bbafd0ae641/77d61c6b-f38a-4c84-83ae-b4e34c7fa531.png)
Confirm by clicking 'YES'
![](https://storage.crisp.chat/users/helpdesk/website/0e35a1b5-ce97-4d12-a27e-1bbafd0ae641/911dd6d1-66bb-4a7c-bf2d-e716debd1c09.png)
Click the Import tab. Next, click the Choose File button to browse for the MySQL backup. Lastly, press the "Go" button to complete the import process.
![](https://storage.crisp.chat/users/helpdesk/website/0e35a1b5-ce97-4d12-a27e-1bbafd0ae641/a12bb883-0ed6-4ddc-aadc-68827667e543.png)
Note: This is the only way for restoring SQL query not larger than 2 MB. For larger MySql database restoration, we recommend you to run mysqldump query from SSH shell.
![](https://storage.crisp.chat/users/helpdesk/website/0e35a1b5-ce97-4d12-a27e-1bbafd0ae641/13f1de77-1a19-4c1a-b96e-8b4e90ffbdcc.png)
Select the database which you wish to restore to the drop down database menu at the left. In this example, I'm selecting the database "joshipro_wptest1"
![](https://storage.crisp.chat/users/helpdesk/website/0e35a1b5-ce97-4d12-a27e-1bbafd0ae641/ee3a586e-ea58-49c5-a084-2a847e0e1f83.png)
The phpMyAdmin script that restores your database does not drop the tables first. Click the Check All / Check tables having overhead check box.
Click the With selected: drop down menu and choose Drop.
![](https://storage.crisp.chat/users/helpdesk/website/0e35a1b5-ce97-4d12-a27e-1bbafd0ae641/77d61c6b-f38a-4c84-83ae-b4e34c7fa531.png)
Confirm by clicking 'YES'
![](https://storage.crisp.chat/users/helpdesk/website/0e35a1b5-ce97-4d12-a27e-1bbafd0ae641/911dd6d1-66bb-4a7c-bf2d-e716debd1c09.png)
Click the Import tab. Next, click the Choose File button to browse for the MySQL backup. Lastly, press the "Go" button to complete the import process.
![](https://storage.crisp.chat/users/helpdesk/website/0e35a1b5-ce97-4d12-a27e-1bbafd0ae641/a12bb883-0ed6-4ddc-aadc-68827667e543.png)
Note: This is the only way for restoring SQL query not larger than 2 MB. For larger MySql database restoration, we recommend you to run mysqldump query from SSH shell.
Updated on: 15/08/2018
Thank you!