Importing MySQL databases and tables using phpMyAdmin

Importing MySQL databases and tables using phpMyAdmin


In this tutorial we’re going to take a look at how to import mySQL databases and tables using phpMyAdmin. We’re also going to assume that you have already logged into phpMyAdmin and are ready to begin. Click on one of the databases is now. Notice that there are no tables in this database. On the right hand side, we have several tabs. One of these tabs is the “import” tab . Let’s click on that now. Under the import tab you have several options primarily, take a look at the “Browse your computer:” option which lets us browse for any file that we wish to upload. Let’s upload this database file, at this time. At this point you can also select various other options such as defining the format of the file and… …telling the machine what type of compatibility to use. For this demonstration we’re just going to leave everything as default. Press the go button to preceed. Notice we are given a message that says that the import has successfully been executed and now there are two new tables inside of our database. Congratulations! You now know how to import databases and tables into phpMyAdmin.

Danny Hutson

19 thoughts on “Importing MySQL databases and tables using phpMyAdmin

  1. My original database disappeared in phpmyadmin. I created a backup database that is on my desktop. I would like to import this backup database into my phpmyadmin . Backup does not have a .sql file. How do I go about creating a .sql file for my backup?

  2. I made a SQL file by exporting.but when I am trying to import it shows that there is some error with my stored procedure.

Leave a Reply

Your email address will not be published. Required fields are marked *