Root - PhpMyadmin

Hi,
I have a question!

I have a server, I want to import a db from phpmyadmin but when I want to goto phpmyadmin it says no access with root!
But I have logged in with user/pass not with root/pass

Any idea?

 

Have you granted yourself access as root user either via Webmin of root Cpanel?

It seems to me just a matter of user/database permissions, but if you are able to login with your username and password you can import your database using bigdump, just open the file to fill in the corresponding settings.

Bigdump is available here, www.ozerov.de/bigdump.php

 

how can you import database and why import it?

 

With bigdump you simply modify the file to reflect you MySQL settings, upload your script and your database file. Then you call the script from your browser, choose the sql file to import and the script does the rest of the job.

Why should you import a database?
Mainly when you are recreating such db from one hosting service to another, or when you need to restore a db which data was corrupted or a database mistakenly deleted.