Importing Databases and Tables with phpMyAdmin

 

  1. This tutorial assumes you've already logged in to phpMyAdmin.
  2. Now let's learn how to import a database.
  3. Click the database you wish to import here.

    phpma-import-frame03_1

  4. Let's assume the data in our details table is corrupt, and we want to import a saved (exported) copy of the data.
  5. Therefore, let's first delete the existing details table from our database.

    phpma-import-frame05_1

  6. Now let's import the saved copy of our database, which includes the details table.

    phpma-import-frame07_1
     
    phpma-import-frame09_1
     
    phpma-import-frame14_1

  7. That's it! The demo1234_members database has been successfully imported, as indicated here.

 

Be Sociable, Share!

Published by

Here's 75 % off, Launch a New VPS Today. Find out why 30,000 customers have chosen our Best-in-Class Performance & 24x7 Heroic Support