Importing databases and tables with phpMyAdmin Print

  • 0

how to import databases and tables using phpMyAdmin:

Step 1: Log into phpMyAdmin:

Ensure that you are logged into your phpMyAdmin account.

Step 2: Navigate to the Database and Table:

The phpMyAdmin main screen is divided into two sections. On the left-hand side, you'll find your database listed. Below the database, you will see the names of the tables within that database. The right-hand side is a large white window where you will perform your tasks.

Step 3: Select the Database:

Start by clicking on the database in the panel on the left-hand side. This action will open a window displaying details about the selected database.

Step 4: Delete the Corrupted Table:

If you need to replace a corrupted table, you should first delete it from your database.
- In the right-hand window, locate the table you want to delete.
- Click on the box at the beginning of the table row.
- Click on the delete icon, represented by a red X.
- A confirmation pop-up will appear; click "OK" to confirm the deletion. The screen will then display a confirmation that the table has been deleted.

Step 5: Import a Saved Copy:
- Click on the "Import" button at the top of the page. This will open the Import screen.
- In the "File to Import" section, look for the "File" field.
- Click on the "Browse" button to specify the location of the text file containing the saved copy of your database.
- This will open your local computer's file upload screen. Locate the database file and click "Open."
- You will be taken back to the Import screen. Click the "Go" button.

Step 6: Database Import:

The database will start importing, and the right window will confirm the success of the import.


Was this answer helpful?

« Back