> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.serverfreak.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# How to Import/Restore Your MYSQL Database Using phpMyAdmin

1. Login to **cPanel** and select **PHPMyAdmin**

![](https://storage.crisp.chat/users/helpdesk/website/0e35a1b5-ce97-4d12-a27e-1bbafd0ae641/13f1de77-1a19-4c1a-b96e-8b4e90ffbdcc.png)




2. 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)




3. 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)
 



4. Confirm by clicking **'YES'**

![](https://storage.crisp.chat/users/helpdesk/website/0e35a1b5-ce97-4d12-a27e-1bbafd0ae641/911dd6d1-66bb-4a7c-bf2d-e716debd1c09.png)




5. 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.