Importing databases and tables with phpMyAdmin Print

  • 210

This article is to teach you how to import databases and tables with phpMyAdmin. We will be expecting that you are by now signed into phpMyAdmin, and for the goal of this article, we will use a database with two tables as our example. The phpMyAdmin main screen is divided into two areas. The left hand side is blue, and this is where you will see your database enumerated. Beneath the database, you will find the names of the tables that are in the database. The right hand side is a huge white window, and this is where the activity takes place.

Let's start by selecting on the database in the panel on the left hand side. This will open a window showing the details of the database. You're now going to import a saved copy of one of the tables. You learned in another article, "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 goal of this article that one of your tables has become corrupt.

The first thing you must do is delete the table you are changing 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. Hit OK, and the table has been deleted. The screen will now give you a confirmation that the table has been eliminated.

By now you need to import the saved copy of your database, which consists of the deleted table. Simply 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. Select on the Browse button. This will open your local computer file upload screen. Look for the database, and click on it. Click Open. This brings you back to the Import screen, where you must click on the Go button.

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


Was this answer helpful?

« Back