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

    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.

If you followed the above steps you have successfully imported database.

Vivek Vengala

Vivek Vengala is a Online Entrepreneur, Web Developer from Hyderabad India.

Click Here to Leave a Comment Below 0 comments

Leave a Reply: