Tip: Start typing in the input box for immediate search results.

< Back
Print

Import a Database – cPanel

Learn How to Import a Database in cPanel using phpMyAdmin. You may occasionally need to import a database from your web host. Possible reasons: 

  • you are transferring a MySQL database from one hosting account to another
  • Importing a third-party MySQL database.

Steps to do before this tutorial:

You need to create a new MySQL database, a new user, and assign the user to the database. Follow this tutorial.


Video tutorial – Import a Database in cPanel


Step-by-step tutorial – Import a Database in cPanel

  1. Login to cPanel.

    Tutorial: login from the Client Area or the direct link.

    Find the Databases section and click the phpMyAdmin link.

    Extilum cPanel - Databases - phpMyAdmin

  2. phpMyAdmin Interface

    In the left pane of the phpMyAdmin page, click the database that you want to import the data into.

    Extilum cPanel - Databases - phpMyAdmin

  3. Click on the Import tab in the top center pane.

    Extilum cPanel - Databases - phpMyAdmin

  4. Importing into the database

    File to Import
    Click the Browse button.
    Select the .sql file on your local computer.
    Partial Import
    Deselect the Allow the interruption of an import.
    Format
    SQL

    Extilum cPanel - Databases - phpMyAdmin

  5. Importing into the database

    Click the Go button at the bottom to the page.

    Extilum cPanel - Databases - phpMyAdmin

  6. Wait for the success message.

    Extilum cPanel - Databases - phpMyAdmin

  7. Check the database tables

    All tables will show when selecting the database in the left panel of phpMyAdmin.

    Extilum cPanel - Databases - phpMyAdmin

Was this article helpful?
0 out of 5 stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
5
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.