To manage MySQL databases, you can use the administrative interface phpMyAdmin in cPanel. Please note, that while phpMyAdmin is used for managing databases, databases and database users cannot be created through phpMyAdmin.

In order to import a database, you need a database backup file, which is generally a file with a ".sql" extension (but .zip, or tar.gz are acceptable formats as well). There are currently two main requirements for importing a database with phpMyAdmin:

  1. The tables must not already exist in the database you are importing to. If you are replacing tables in an existing database, you will need to "drop" the tables first.
  2. The database must be under 50MB. If you have a database over 50MB, please upload your database backup (using ftp or the cPanel file manager) into your account's home folder and email This email address is being protected from spambots. You need JavaScript enabled to view it. for further assistance. Please be sure to include the filename, what database you want the file imported to and account verification (either your AMP password or the last 4 digits of the credit card on file).

To import a Database:

  1. Log into your cPanel Account.
  2. Click on the phpMyAdmin icon under Databases in the cPanel home screen.
  3. Select the database that you want to import into from the list in the left menu by clicking the database name.
  4. Click the "Import" tab in the top menu.
  5. Under "File to import", click "Browse" and find your database backup file.
  6. Click the "Go" button on the bottom right.
  7. Once the import is complete, just under the tabs, you should see a green check mark and a notification similar to: "Import has been successfully finished, ## queries executed."

Complete steps 3-7 if you need to import backups to multiple databases.

phpmyadmin-import

Did you find this article helpful?

We value your feedback!

Why was this article not helpful? (Check all that apply)
The article is too difficult or too technical to follow.
There is a step or detail missing from the instructions.
The information is incorrect or out-of-date.
It does not resolve the question/problem I have.
How did you find this article?
Please tell us how we can improve our Help Center:
Email Address
Optional, but our team may contact you for more information.
Did you find this article helpful?

Post a Comment

Name:
Email Address:
Comment:
Are you a bot?
Submit

Please note: Your name and comment will be displayed, but we will not show your email address.

Related Questions

Here are a few questions related to this article that our customers have asked:
Would you like to ask a question about this page? If so, click the button below!

Help Center Search

Current Customers

Email: support@WebHostingHub.com Ticket: Submit a Support Ticket
Call: 877-595-4HUB (4482)
757-416-6627 (Intl.)
Chat: Click To Chat Now

Ask the Community

Get help with your questions from our community of like-minded hosting users and Web Hosting Hub Staff.

Not a Customer?

Get web hosting from a company that is here to help.