In this tutorial:

In this tutorial, we will show you how to import a MySQL Database using phpMyAdmin.

Prerequisites

We'll assume that you've already exported your database, and it is either a .sql, zip, or tar.gz file. You should have already created the new database that you're importing into as well.

How to:

  1. how-to-use-phpmyadmin-to-import-a-database Log into cPanel
  2. Open phpMyAdmin by clicking the phpMyAdmin icon
  3. Select the database in the left menu that you will be working with
  4. Click Import in the top menu
  5. Under File to Import, click Browse and select the backup file you previously created (it will be either a .sql .zip or .tar.gz file).
  6. Click Go at the bottom right
  7. When the database has been imported successfully, you should see a message at the top of the page similar to: Import has been successfully finished, ## queries executed.

    Congratulations, you have just imported a database!

Troubleshooting

#1044 - Access denied

If you get the following error when importing a a database through PhpMyAdmin, you will need to edit the sql file you're trying to import.

CREATE SCHEMA IF NOT EXISTS `DataBaseName` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

MySQL said: Documentation
#1044 - Access denied for user 'userna5'@'localhost' to database 'DatabaseName'

PhpMyAdmin does not allow you to CREATE databases due to security reasons. In order to get your SQL file to load you will need to remove the CREATE SCHEMA line at the beginning of your code, this tutorial here can help

50+ MB databases

If the database that you are trying to import is over 50 MB in size, then you will not be able to import the database through phpMyAdmin on shared servers.

VPS and Dedicated Servers

Only VPS/Dedicated server accounts with root access can import a database larger than 50 MB using the command line access. For more details on the actual command, go to mysqlimport - a data import program.

Shared servers

For users on shared hosting, you can follow these steps to import a database larger than 50MB.

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!

Support Center Login


Social Media Login

Related Questions

Here are a few questions related to this article that our customers have asked:
Ooops! It looks like there are no questions about this page.
Would you like to ask a question about this page? If so, click the button below!
Ask a Question
n/a Points
2014-09-10 10:55 am
u should let people know how to create the database before actually going ahead to import.some dont know.i knew it already and to me this was cool and direct.
kudos!
n/a Points
2014-09-11 2:29 am

find this error 

 

You probably tried to upload a file that is too large. Please refer to documentation for a workaround for this limit. 

Staff
23,122 Points
2014-09-11 6:39 am
Hello adesh,

50MB is the size limit for database imports on a shared server. You will need to contact Live Support to have them import anything larger than that. You can go ahead and upload the database file to your account, preferably in the home directory or public_html folder. Be sure to indicate the name and location of the file in your request. As always, be sure to verify your request with either the last 4 digits of the credit card on file or the current AMP password if sending an email.

Kindest Regards,
Scott M
n/a Points
2014-10-01 11:12 am
When you import to an alternative database how can you be sure that all the previous data is removed. Is import destructive or only additive. If you want it to be an exact duplicate of the imported DB do you need to drop the previous tables or delete all the rows?
Staff
11,156 Points
2014-10-01 11:15 am
Before importing, you will need to drop all previous tables if you are overwriting existing data.
n/a Points
2015-01-26 5:52 pm

i get this error when tray to import a file of 33mb size

"The connection was reset"

Staff
23,122 Points
2015-01-26 6:31 pm
Hello Atman,

Typically, waiting a bit should clear this up. If you continue to receive the error, you will want to contact our Live Support department to have them take a look at your individual situation.

Kindest Regards,
Scott M
n/a Points
2015-02-02 3:01 pm

Hi, 

I am new to using phpMyadmin. I followed your procedure and the import was successfull. However after importing, if I click on "My Website" in it, i get error in connection. I already have any existing website in wordpress and would like to know how I should connect it to the phpMyadmin.

 

thanks.

Staff
20,715 Points
2015-02-02 4:31 pm
Hello Vishal,

If you imported the installation, then you would have needed to change the settings for the database in your wp-config.php file. Check out this article for further assistance: Error Establishing Database Connection. You may also need to review this tutorial on finding your database name.

I hope this helps to answer your question, please let us know if you require any further assistance.
Regards,
Arnel C.

n/a Points
2015-02-03 2:13 am

Created my db just fine along with a db user just fine.  But when I import it says i do not have permission to create a table.  Issue is this:  My cpanel login is 'xy' (not really).  All users that I create for the db have to be 'x_' something.  When I go into phpMyAdmin, it never asks me to login, it just lets me in and says I am 'xy'@'localhost'.  My question is how to I tell phpMyAdmin to be 'x_dbuser'@'localhost' (which I created) instead of 'xy'@'localhost' (who I cannot create as a db user and so does not have access to the db)?  It must be something simple but I cannot find it.

Staff
11,156 Points
2015-02-03 9:59 am
The main cPanel user should have access to all databases. Could you provide the exact error you are getting?
n/a Points
2015-02-18 3:08 pm

Hi Jeff,

I'd be happy if you can help me.

I backed my files by ftp.

My host opened a new domain name. And created a brand new site.

I updated the wp-config file and tried to import it bu phpmyadmin, but with no success.

I sent all my old files to the new site by ftp.

Is there any missing logic on my actions?

Also is the database only wp-config ? 

Thanks

Staff
1,168 Points
2015-02-20 11:05 am
Hello Baris,

I believe there is some miscommunication somewhere as the wp-config.php file has the database connection information and is not the database itself. I would suggest contacting your old host and request a backup of the database specifically as you can not back up the database solely from FTP.

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

14 Questions & Comments

Post a comment

Back to first comment | top

Need more Help?

Search

Ask the Community!

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

Current Customers

Chat: Click to Chat Now E-mail: support@InMotionHosting.com
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!