Put my mind at rest please!

[Drunkencelt]

Hi,

Might be very thick here but having spent the last three hours trying to work out why phpmyadmin will not let me port my local database to my remote "new" database with EUKhost I might just have worked out what I am doing wrong.

My local database is called "xxxx". I have exported (backup) the contents to a sql file. I have then created a new database called "xxxx" to which EUKhost appends "yyyyy_". Ok so my database is called "yyyyy_xxxx". When I try to import my sql file through phpmyadmin I get an error

Create schema xxxx--
CREATE DATABASE IF NOT EXISTS xxxx;
MySQL said: Documentation
#1044 - Access denied for user 'yyyyy'@'localhost' to database 'xxxx'

Now is this because both databases have to be called the same? ie if I work on a local database for development that I intent to eventually upload to my remote server do I have to always append "yyyyy_" to the name? If I've not done so is it possible to rename a database prior to backing it up for uploading?
Or......have I got this all wrong?
I've been on to support who have uploaded the file for me but I still don't know what I am doing wrong so will only fall again in future.

All advice appreciated.

Cheers

[Drunkencelt]

Thanks,

Worked it out for myself now after after having another look (and a beer!).

Yes they do have to be the same name and yes I can change a name by creating a new database with the name I want and import the backup into it using MySQL Administrator.

Funny how everything makes logical sense AFTER you've worked it out AND posted a query. Anyway it might help someone else as thickas I!?



Cheers