phpMyAdmin — How to import or restore a database or table

View the following article for details on how to find your login credentials:

Restoring a database

  1. Log into phpMyAdmin.
  2. Select the destination database on the left pane.
  3. Click on the Import tab on the top right pane.
  4. Under the 'File to import' section, click Browse and locate the file with the .sql extension you saved earlier.
  5. Check or uncheck the boxes for 'Partial import' and 'Other options'.
  6. From the 'Format' dropdown menu choose 'SQL'.
  7. Click the Go button at the bottom to import the database.

If you imported a database, all tables will show when selecting the database in the left panel of phpMyAdmin.

If you imported a table, the newly-imported table will appear in the list of tables.

See also

Did this article answer your questions?

Article last updated .