Export and importing mysql db from localhost to provider #1044 error

[loopynutter]

Hi,

I have a database in MySql accessing it via PHPMyAdmin... I am now trying to export this from my localhost so that I can import it to my hosting provider, again via phpmyadmin.

I have tried creating an account with the same username and password on the local host as the provider... and granted all privaledges.. then done the export but when I import on the host phpmyadmin I get the #1044 error - Access Denied

Please help

Thanks

[Guest]

In some import dialogs there is an option for local/remote host. It seems contrary at first, but this should be "local" even though the database is on your host. That has been known to cause access denied problems.

Barry