How to import a database using PHPMyAdmin

How to import a database using PHPMyAdmin, before importing database you need to have database file which will be imported in other web server. First create a database and select that database, after that you can see list of tabs on top, click on import under “File to Import:” select the sql file or compressed sql file and upload it into database.

You can upload a file with limited file size, you can get this size right after the file input field. If you want to upload large sql file read this -> How to Import large sql database files into MySql using command line

If you are on localhost navigate to localhost/phpmyadmin or if you are on web server navigate to server’s phpmyadmin then login to phpmyadmin with login credentials.

After Login to PHPMyAdmin, create a database to import the sql file.
For creating a database, click on database and enter the database then click on create button.
How to import a database using PHPMyAdmin
After creating the database, select database for importing sql file.
From the top menu, click on Import link.
On the import screen, select sql file to import and click on go button.
After few minutes, you will see a success message.