Client Area↗

Knowledge base › Databases & PHP

How to import a database with phpMyAdmin

Load a .sql backup into a database.

Where
cPanel → Databases → phpMyAdmin
Time
5 minutes
You need
A .sql or .sql.zip file
  1. 1

    Open phpMyAdmin

    In cPanel, in the Databases section, click phpMyAdmin. It opens in a new tab.

  2. 2

    Select the database

    In the left column, click the database you want to import into.

  3. 3

    Open Import

    Click the Import tab at the top.

  4. 4

    Choose the file

    Click Choose File and select your .sql file. Leave the other options as they are.

  5. 5

    Import

    Scroll down and click Import (in some versions Go). A green message confirms it worked.

Good to know
  • Very large files can time out. Contact us and we’ll import them for you.

Stuck on a step? Open a ticket and tell us the step number.

← All 31 guides