CMS Made Simple Forums

I'm sorry for being so dull...

I'm trying to restore a database onto a new server. I created a backup of my database from using MySQL Administrator.

I then created a new blank database on which has a database owner "restoretest" whose password I specified.

When I connect to and try to restore the database to it, I get the message

"Error while executing this query:CREATE DATABASE IF NOT EXISTS cukAcmsms;
The server has returned this error message:Access denied for user 'restoretest'@'%' to database ''
MySQL Error."

I'm certain i'm missing something very simple, but why can't I restore the database? Must I create a new user on whose username is the same as ?

This is not a CMSMS issue.

Right you are Robert.

In case anyone else stumbles across this issue, it's now resolved and here's what was up:

I was using MySQL Administrator, which my host's documentation advised. Unfortunately they didn't tell me what settings to use with all the configurable areas and some of the defaults are wrong for use with Fasthosts (ironic name).

For backing up:

Backup Execution Method: By default this was set to "InnoDB". Needed to be "Normal Backup".

When it came to restoring:

By default the Target Schema was set to "Original schema". This needed to be "" (whatever you blank database you created was called).

After that a quick edit of config.php and off we went. Lovely.

On a side note, i'd advise people not to go with Fasthosts. I was landed with the hosting accounts so didn't have much choice, but the PHPMyAdmin install you have access to is locked down. You can't create databases or users through it.