phpmyadmin - rename database

[dixieau]

Is there a way to rename a database?

I have tried renaming, I get this:
Error

SQL query: Edit

CREATE DATABASE `name` ;

MySQL said: Documentation
#1044 - Access denied for user 'xxx'@'localhost' to database 'name'

I hav also tried to copy it with the same result, any ideas please?

[vegasgwm]

You should do it in the BH CP, not in phpadmin.

[Engineerly]

I do not see an option for renaming a database in "MySQL databases" formthe bluehost cpanel. Did they remove it or move it?

Thanks,
Ron

[wysiwyg]

It doesn't appear to be possible to rename a database after it's been created, since you don't have permissions to name databases, and cpanel doesn't give the option to do so.

You could export and import the data into a new database though.

[felgall]

The only way to do it would be to first create a new database, then use the export option to export everything from the old database, then use the import option to import that into the new database, then delete the old database. The last 3 of these 4 steps can be done from phpmyadmin while the first step needs to use one of the two options to its left on the cPanel menu.

[Engineerly]

Thanks Stephen those steps worked.

[Engineerly]

Stephen,

I want to re-open this issue. Is this the way that we do backups of our databases?
I tried to use the phpMyAdmin -> Operations -> Copy Database to, since that seems intuitive but got the 1044 error like the OP.
I then tried to create the backup database first, but still got the same error weird.

Then I rediscovered this thread and use the export -> import procedure which seemed to work.

That was pretty easy, but still seems awkward since there appears to be a built-in phpMyAdmin utility exactly for that. What good is a database copy utility if the account owner can't even use it?

hmmn... wait there's more! ... I have WAMP installed on my PC and that same utility works perfectly (at http://localhost/phpmyadmin) so like many computer system issues this one is about "insufficient privileges" or some funky mis-configuration. Are there any plans to fix this, cuz it's kind of crippled as is?

Thanks,
Ron

[felgall]

The insufficient priviledges is because you are sharing mysql with every other account on the server and so any command that would potentially allow you to access any of the other databases is disabled.