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!