error while importing database in phpmyadmin

Asked by:
khushi / 5 Points
Time:
2012-08-27 2:38 am EST
Category:
Databases
Hits:
1,026
initially when tried to import database, an error ocurred....
"you probably tried to upload too large file"
when i increased the following values...another error ocurred..
max_evecution_time = 60
max_input_time=90
memory_limit=128
upload_max_filesize =128
post_max_size=16

and the error which appeares after this..


sql query:
-
-database "Information_Schema"
-

create Database 'Information_Schema'
DEFAULT CHARACTERSET utf8 COLLATE utf8_general_ci;

mysql said:
#1044 - Access denied for user 'root '@' localhost' to database 'information_schema'

To ask this user for more information, please first login.

To submit an answer, please login.

ANSWERS

0

bradm
Staff
1,846 Points
2012-08-27 12:20 pm EST
Hi khushi,

The error message you are receiving can be caused by numerous things. If you are hosting your website on a hosting provider that offers cPanel, such as Web Hosting Hub, the problem is caused by the fact that you can only create databases within cPanel. If the file you are trying to import has a line similar to:

create Database

... the import will fail.

For more information about this error, I recommend reading our articles on why do I get a 1044 error and resolving a 1044 mysql error.

I hope this helps! Feel free to leave a comment at the bottom of this page if you need any further assistance.

Thanks!
- Brad

To submit a comment on this answer, please first login.

Want to share this Question?

Related Articles

It looks like there are no related articles.
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.