Learn to import a MySQL Database in cPanel

When you want to move your website to a different hosting provider or implement disaster recovery, you must import a database. Make sure you need to build a database backup in order to import before proceeding.

Perform the following steps to import a database backup :

1) Log in to your cPanel account.

2) Scroll down to the Databases section and select phpMyAdmin.

3) On the phpMyAdmin page, click on the Import tab at the top of the page.

4) The import page gets open. On this page, go to the File to import section at the top, and click on the Choose file button. A dialogue box gets open from where you can find the database backup file that you wish to import from your device.

5) After choosing the file that you want to import, leave the below settings with their default values (as in the below images) and click on the Go.

That’s it.