How to upload a database??

hey freinds ,
can anyone tell me how to upload a database?
actually i have a web directory site, now i have changed my hosting and back up my database..
but now when i am uploading the database, a SQL error is coming
Please can anyone tell me the proper procedure to do..

Sorry, if wrong section

 

You have to upload the sql file in phpmyadmin

 

see,
i am doing like this
1st going to phpmyadmin
then import then select that file then go...
and after that i am getting that err.....

 

Whats the error

 

how big is the database, if its too big phpmyadmin just won't do it.

this belongs in databases so i'll move it.

 

Echoing the "what error are you receiving" request as well.

And just in case if it is over a meg or two in size, do you have root or ssh access to do it from the command line?

Best solution would be to upload it as a normal file to your webspace, drop your host an email and ask them to import it into the specific database that you need it in. They should be able to import it if the file is too large for phpmyadmin.

 

Error

SQL query:

--
-- Database: `information_schema`
--
CREATE DATABASE `information_schema` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

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

 

Open your databese file in notepad

Find and remove this line

CREATE DATABASE `information_schema` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

Code (markup):

after that save it and try to import it after that it will work

 

if you can open that sql file in a text editor, at the top, remove everything up to Create Table.

its reading off the old host.

so how big is this database?


damn, too slow again.

 

Something's wrong here. 'information_schema' is an internaly used CPanel database. That shouldn't be exported here and used.

 

it is 253 kb

 

Wrong quote there.

If you understand MySQL, then take a quick look through and see what's happening.

If you're willing to pay to get the problem fixed, I'd be interested.

 

do what sawz said.. that should work.. you can google the error ofcourse

 

lol this time i was first lol thanks for the rep cant rep u back unlike u i have a daily rep giving quota and mines over

 

nice catch, i didn't even think about that.