Importing Databases and Tables with phpMyAdmin

Reading Time: < 1 minute

 

  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.

 

Get 33% off the first 3 months on a new VPS! Find out why 30,000 customers have chosen our Best-in-Class Performance & 24x7x365 Support