How to import a database using phpMyadmin in cPanel?

We assume that you have already exported your database or have a MySQL dump file that you want to import and you have also created a new database where you want to import this.

Log into phpMyAdmin

Login to your cPanel and look for an icon called PHPMyAdmin and click on it. If you are not using cPanel, please contact your hosting provider on how to do this.

Open phpMyAdmin by clicking the phpMyAdminicon

Select the database in the left menu that you will be working with. This is the database you you created earlier where you want to import your backup.

Click Import in the top menu

Under File to Import, click Browse and select the backup file you previously created (it will be either a .sql .zip or .tar.gz file).

Click Go at the bottom right


When the database has been imported successfully, you should see a message at the top of the page similar to: Import has been successfully finished, ## queries executed.

Congratulations, you have just imported a database!



Was this helpful?

0 / 0