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 this article:
Email Address
Name

new! - Enter your name and email address above and we will post your feedback in the comments on this page!

Did you find this article helpful?

Comments

n/a Points
2014-11-07 10:06 pm

I tried this but it did not work.  I got the error "#1044 - Access denied for user 'barbad7'@'localhost' to database 'bbsas001_ssmaillist'"

How do I fix this.

Staff
1,198 Points
2014-11-07 11:14 pm
Hello Trevor,

I checked your account and was not able to find the sql file you are trying to import. You may need to edit the .sql file and comment the line starting with CREATE DATABASE by putting a hashtag (#) in front of CREATE. You may also contact our support department for assistance on uploading your database.

Kindest Regards,
TJ Edens

Post a Comment

Name:
Email Address:
Phone Number:
Comment:
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!
Need More Help?

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.
}