How to import databases and tables using phpmyadmin


This tutorial is to teach you how to import databases and tables within phpMyAdmin setup. We will assume that you are currently logged into phpMyAdmin, and for the purpose of this tutorial, we will use a database with two tables as our example. The phpMyAdmin main screen is broken into two sections. The left hand side is blue, and this is where you will find your database listed. Below the database, you will see the names of the tables that are in the database. The right hand side is a large white window, and this is where the activity takes place.

Let’s begin by clicking on the database in the panel on the left hand side. This will open a window showing the details of the database. You are now going to import a saved copy of one of the tables. You learned in another tutorial, “Exporting databases and tables with phpMyAdmin” how to export a copy of your data to your local computer to save it. It is a good idea to do this in case the data should become corrupted in your database, and you need to reload it. let’s say for the purpose of this tutorial that one of your tables has become corrupt.

The first thing you need to do is delete the table you are replacing from your database. In the right hand window, click on the box at the beginning of the table row, and then click on the delete icon, which is the red X. A pop-up will ask you to confirm the delete. Click OK, and the table has been deleted. The screen will now show a confirmation that the table has been deleted.

Now you need to import the saved copy of your MySQL database, which includes the deleted table. Click on the Import button at the top of the page. This will open the Import screen. The first box is File to Import. The first line asks the location of the text file. Click on the Browse button. This will open your local computer file upload screen. Find the database, and click on it. Click Open. This takes you back to the phpMyAdmin import screen, where you need to click on the Go button.

The database will now import. The right window will confirm the success of the import. This is the end of this tutorial. You now know how to import a database with phpMyAdmin.

Advertisements

3 thoughts on “How to import databases and tables using phpmyadmin

  1. Pingback: How to delete fields from a database tables using phpmyadmin | DMM

  2. Pingback: How to modify fields in database tables using phpmyadmin | DMM

  3. Pingback: How to run SQL Queries on a database using phpmyadmin | DMM

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s