phpMyAdmin — How to Import or Restore a Database or Table


We will be going over a step by step guide on how to import a database or table through your phpmyadmin database manager in cPanel.

Import or restore a database or table

Log into phpMyAdmin through your cPanel dashboard



Select the destination database on the left pane.

Click on the Import tab in the top center pane.

Under the ‘File to import’ section, click Browse and locate the file with the .sql extension you wish to import.

Check or uncheck the boxes for ‘Partial import’ and ‘Other options’.

From the ‘Format’ dropdown menu choose ‘SQL’.

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.

What about exporting a table?

If you’re interested in backing up or exporting a database or table, follow this guide.

Was this article helpful?
0 out of 0 found this helpful

Articles in this section

Reclaim Hosting Support Hours
8:00 am - 5:00 pm ET, Monday through Friday
Submit a Ticket
Get a quick and helpful response from the pros.
Need Extra Support?
No problem, we're here to help! Talk to us about Professional Services or custom Service Level Agreements.