problem in restoring the database

[bluemagix]

i have an .sql file and i want to use it in my database.

whenever i saY import and try to restore the data.
i am getting an error as ::

#1044 : Access denied for user '********@'localhost' to database '******'

i checked multiple thigs for it
1>I checked config.php file. in which i look at username and database name is proper or not.
2>I also gone through permissions that are granted to the user.


but i am not able to understand where the problem is.

can any one help me out plzzzzzzzzzzzzzzz

[Eriksrocks]

What software are you using to import the .sql file? Make sure you are using phpMyAdmin.

[bluemagix]

I am using phpmyadmin only.
I have also noticed that in main window of phpmyadmin
Create new database: No Privileges
n tried uploading data from mysql database also.
it is showing restoring database but noting is getting done.

I am really getting tension of it.

[hollenback]

To create a database and add users you need to go to "MySQL Databases" in cPanel.
After you create it you can use phpmyadmin to import the tables.

Bill

[bluemagix]

Thnks
but i have done through that way only nad i am not able to be successful

It was a my site databse that i want to upload in the new site.
and i am not able to do it ....

[indowill]

Anyone ever tried restoring a MySQL database via cPanel? I tried uploading a .sql file using the Restore Database functionality. It looks like it's working, and I got redirected to a blank page, with the words Restoring Database written on it... and just hangs there for the longest time. Is it supposed to work like this? Because it looks like the database didn't change at all.