SQL Database File Importing Error

I am trying to import my sql database file to my godaddy shared hosting account. It gives following Error:

#1044 - Access denied for user 'tec1104206581824'@'%' to database 'information_schema'

Please guide me what to do...

 

Do you have dump of database information_schema in the dump file? If it is so, remove it from the dump and try again.

 

I have no idea about dump file, where it is?

 

I mean mysql database file.

 

Inside the .sql file you are trying to import, check for `information_schema` and ensure all references, and table creation / data insertion queries for that database is removed.

 

you should either upload it via ftp and then restore it via ssh with a set mysql user and password or use phpmyadmin or give the .sql to your tech support to do this for you

 

information_schema is a MySQL admin table and probably you don't have root access to overwrite it. I presume you dont need this table. Just delete all the references to this table and uplaod the script/dump again

Regards