InMotion Hosting Support Center

In this tutorial:

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


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!


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


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

31,840 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
2015-07-13 6:54 am

I have different kinds of database files with me I dont know how to import those files (like, OPT, FRM, MYI, etc)

can anyone suggest what to do?

31,840 Points
2015-07-13 2:40 pm
PhpMyAdmin allows for the following import formats: SQL, MediaWiki Table, OpenDocument Spreadsheet, CSV, ESRI Shape File, or XML
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?
11,186 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"

31,840 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


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.



28,466 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.
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.

11,186 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 ? 


7,105 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.

31,840 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

28,466 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.

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


31,840 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
n/a Points
2015-06-10 3:07 am



Comando SQL:


---- Database: `joomla`---- ------------------------------------------------------------ Table structure for table `#__assets`-- CREATE TABLE IF NOT EXISTS `#__assets` (

`id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key', `parent_id` int( 11 ) NOT NULL DEFAULT 0 COMMENT 'Nested set parent.', `lft` int( 11 ) NOT NULL DEFAULT 0 COMMENT 'Nested set lft.', `rgt` int( 11 ) NOT NULL DEFAULT 0 COMMENT 'Nested set rgt.', `level` int( 10 ) unsigned NOT NULL COMMENT 'The cached level in the nested tree.', `name` varchar( 50 ) NOT NULL COMMENT 'The unique name for the asset.\n', `title` varchar( 100 ) NOT NULL COMMENT 'The descriptive title for the asset.', `rules` varchar( 5120 ) NOT NULL COMMENT 'JSON encoded access control.', PRIMARY KEY ( `id` ) , UNIQUE KEY `idx_asset_name` ( `name` ) , KEY `idx_lft_rgt` ( `lft` , `rgt` ) , KEY `idx_parent_id` ( `parent_id` )


Mensagens do MySQL : Documentação

#1046 - No database selected

28,466 Points
2015-06-11 3:20 am
Hello Abilio,

Apologies for the problem that you're seeing. However, the issue centers around your code NOT selecting a specific database. You may need to speak with a developer if you are unable to correct that issue. We unfortunately cannot correct the code for you.

Kindest regards,
Arnel C.
n/a Points
2015-07-18 7:30 pm

I get this when I try importing SQL file. Pls someone should help me out on how to solve this problem:



There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unknown Punctuation String @ 15
STR: ><
SQL: <!DOCTYPE HTML><html lang='en' dir='ltr' class='safari safari4'><meta charset="utf-8" /><meta name="robots" content="noindex,nofollow" /><meta http-equiv="X-UA-Compatible" content="IE=Edge"><style>html{display: none;


SQL query:

<!DOCTYPE HTML><html lang='en' dir='ltr' class='safari safari4'><meta charset="utf-8" /><meta name="robots" content="noindex,nofollow" /><meta http-equiv="X-UA-Compatible" content="IE=Edge"><style>html{display: none;

MySQL said: Documentation

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL ser

31,840 Points
2015-07-20 4:11 pm
Hello Nestor,

The reason for the error is that the data it is reading is not SQL, but HTML. PhpMyAdmin cannot import HTML and convert it to a database. It needs to have a regular SQL Query in order to do so.

Kindest Regards,
Scott M
n/a Points
2015-10-29 12:13 pm

Hello guys!

I'm interested is there any way i can automatically import a database with phpMyAdmin at a given interval? I'd like to have phpMyAdmin import a database from a specific location every 24 hours, or any interval that i like. 

I know how to creat a MySQL Event, if that helps.

28,466 Points
2015-10-29 12:38 pm
Hello Nick,

Currently, the only way to do that is to create a CRON job that launches a script for the database import. The import would need to be written to be executed via command line using MySQL. Check out how to run a cron job for further details.

If you have any further questions or comments, please let us know.

Arnel C.
2015-11-22 4:35 am

I am having issues importing a sql database backup from my old host to a blank database here. I get no errors but the database is still blank and I get no confirmation of completion. I have been able to import the backup to my old host to a blank database and it works fine and i get confirmation that it was successful. One thing i noticed between the two hosts is that my old host, i have to login with the sql username, here there is no way to login as the sql user.
517 Points
2015-11-23 11:26 am
How large is the import? It may be failing due to size, which, in that case we can help you with the import.

Post a Comment

Email Address:
Phone Number:

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

35 Questions & Comments

Post a comment

Back to first comment | top

Need more Help?


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