Import MySQL Database with phpMyAdmin

If you need to restore a backup of your database, importing it to phpMyAdmin is a simple process that can be done with just a few clicks.

  • Step 1: Open your database in phpMyAdmin
  • Step 2: Click Databases in the top-menu
  • Step 3: Click the name of the database you want to import to
  • Step 4: Click Import
  • Step 5: Choose file and click Go
  • Step 6: You’re done

Step 1: Open your database in phpMyAdmin

  • Login to your hosting account
  • Click on phpMyAdmin under the Databases section

Step 2: Click Databases in the top-menu

This will show you a list of all the databases associated with your hosting account

Step 3: Click the name of the database you want to import to

Step 4: Click Import

Step 5: Choose file and click Go

Step 6: You’re done

The import is now done. A message confirming the import appears on your screen. You should be able to see the tables in the column to the left in phpMyAdmin.