InMotion Hosting Support Center

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.

Support Center Login

Social Media Login

   
Social Login Joomla

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
25,902 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
25,902 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
24,124 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
2,776 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
n/a Points
2015-03-15 5:16 am

 

 

Thanks for the info Tj. =)

n/a Points
2015-03-14 12:00 pm

I had a crash on my site, exported a .sql database file. Created a new database inviroment and installed a new version of concrete5 on to de database. When uploading the exported .sql file i get a error #1054 - Unknown column 'fvHasThumbnail1' in 'field list'.

Trying to get it to run again, any help is greatly appriciated. If needed i can share the .sql file.

Staff
25,902 Points
2015-03-16 4:36 pm
Hello Olaf,

That error is when the query attempts to put data from a column in to a table and the database cannot locate that particular column. Be sure to check for spelling errors in either the query or the database itself.

Kindest Regards,
Scott M
n/a Points
2015-04-01 2:13 pm

Hello there, 

 

i had successfully imported the database to the myphpadmin , but still it does not connecting with my website , will u please sort out the problems

Staff
24,124 Points
2015-04-02 10:40 am
Hello Praveen,

Sorry to hear that you're having problems with the database. However, we need more specific information in order to help you with the connection issue. Do you have an account with InMotion? If not, can you please provide the error message you're seeing as well as the configuration information used for connecting to the database? The connection parameters should be verified so that we can at least rule it out.

Regards,
Arnel C.
n/a Points
2015-05-04 1:45 am

I have a website hosted with InMotion, and I used a WordPress plugin to give me a weekly backup of what I assume is the database. The file it sends me each week is a .zip file.

 

The instructions for restoring this backup are the same as what is outilined here:  go to phpMyAdmin in Cpanel, select the appropriate database, select "Import", navigate to the backup file and click on the "Go" button. This is supposed to restore the database to the backup version.

My question is whether this actually replaces the old database with the backup. Does this process remove the old database and replace it with the imported backup? It doesn't really make that clear. I'm worried that I'll just be duplicating all  the content or otherwise making things worse. Do I have to somehow remove the old database first BEFORE I import the backup file or is that done automatically?

 

Thank you very much for your help.

 

Doug Nienhuis

 

Staff
25,902 Points
2015-05-04 8:10 am
Hello Doug,

Yes, the restore will replace the existing database so no data will be duplicated. You can always remove all the data in the database if you like by selecting all the tables and "DROP"ing them. This would give you an empty database shell to restore to. It is an additional step, but a good one if you are not quite certain.

Kindest Regards,
Scott M

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.

23 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!