The Penguin Forums

Firstly, my apologies for what is i'm sure a very basic question.

I inherited control of several sites from a company who ran their hosting through FastHosts (joke name I assume). I've been a long time user of Penguin and so would like to move the sites across.

They're using mySQL databases, which I can export from the FastHosts server using the recommended mySQL Administrator tool. This works fine and I have ensured that the databases are valid by restoring it to additional FastHosts accounts and creating a new working copy of the site there.

I'm now trying to create a copy of the site on one of my Penguin accounts, but in doing so i'm having to find my way around phpMyAdmin. One problem I had in the past before I figured it out in mySQL Administrator was specifying the target schema. I don't see how I can do that in phpMyAdmin, or am I being silly?

Trying to restore the database gives me the error 'Access denied for user xx to database xx'.

That error was solved previously by specifying the empty database I created earlier as the target schema, rather than 'default'. I'm certain i'm confusing myself or doing something wrong, any ideas?

The control panel will not allow database creation via PHPMyAdmin, all databases are created via the control panel rather then using the create database SQL query within PHPMyAdmin, therefore to import a database you will first of all need to create the database via your control panel and then login into PHPMyAdmin and import your database dump. You may receive that error again if the 'create database' query is within the dump, if so just edit the database dump and remove this line which should be located near the top of file.