restore database problem

[zurgenaboy]

smf 2.0.11
used phpmyadmin to export DB from one site
then import DB to a new DB on another site
Checked all available info but still keep getting this message
Can anyone point me in the right direction

CREATE DATABASE  `mydbname` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;


MySQL said: Documentation

#1044 - Access denied for user 'username'@'localhost' to database 'mydbname'

Many thanks for any help.

[Sir Osis of Liver]

localhost does not work on all servers.  You may need the actual path for $db_server in Settings.php.

[zurgenaboy]

In desperation and Contrary to all advice, I went back and used the SMF backup
instead of phpmyadmin.
I then restored to the new DB using phpmyadmin and it now works.

Thank you for your reply.

[zurgenaboy]

The smf backup is now returning a zero byte file, so I am back to square one now.
I have another post open dealing with converting to UTF-8 as that is the message that started this thread.
The main problem is that the existing forum is with a provider that has limited control functions and the backup is with another provider with the normal control panel.
Any more suggestions please.

Forgive the 2 open posts, but I dont know what else to do now.

[aegersz]

eventually, phpmyadmin backups and restore became too unwieldy for me so now I use 'mysqldump' and it's so much faster, simpler and it can be automated as it's a batch process.

You might as well learn how to use it because of the limitations of phpmyadmin as your database grows.