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 ?
[SOLVED] Restoring a database, user access denied...
[SOLVED] Restoring a database, user access denied...
Last edited by Fraserm on Tue Aug 04, 2009 10:15 pm, edited 1 time in total.
-
calguy1000
- Support Guru
- Posts: 8169
- Joined: Tue Oct 19, 2004 6:44 pm
Re: Restoring a database, user access denied...
This is not a CMSMS issue.
Follow me on twitter
Please post system information from "Extensions >> System Information" (there is a bbcode option) on all posts asking for assistance.
--------------------
If you can't bother explaining your problem well, you shouldn't expect much in the way of assistance.
Please post system information from "Extensions >> System Information" (there is a bbcode option) on all posts asking for assistance.
--------------------
If you can't bother explaining your problem well, you shouldn't expect much in the way of assistance.
Re: Restoring a database, user access denied...
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.
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.
