renaming or deleting a database in PHPMyAdmin...

[rufussweetwater]

i am trying to create a new database for my custom forums. so i log into cPanel, click on PHPMyAdmin, and for some reason when i was selecting a database, there was a third database that i didn't make. apparently it was for a shoutbox which doesn't make sense. when i open it its blank, nothing's in it. so i just wanted to either delete it or just rename it. But i cant find the drop command to delete it, and when i go under operations to rename it, it says that i have an error and no privileges to create a new database. all i want is to either rename the database or delete so i can make a fresh one for my custom PHP forum.

Any help at all is much appreciated.

 

[leafypiggy]

What's the name of the database?

It may just be a database that is needed for the others to function properly.

 

[rufussweetwater]

cykadmin_shoutbox

i think the system thinks i made the database. but i didnt...

 

[leafypiggy]

there must have been a shoutbox on your forums or something at one time.

try deleting it from the SQL manager.

http://yoursite.com:2082/frontend/x3/sql/index.html

replace "yoursite.com" with your domain name.

 

[Livewire]

there must have been a shoutbox on your forums or something at one time.

try deleting it from the SQL manager.

http://yoursite.com:2082/frontend/x3/sql/index.html

replace "yoursite.com" with your domain name.

Jumping in, far as I know this all has to be done via cPanel - it seems that however cPanel tracks the # of databases each user has, it ends up requiring that cPanel be the one to add/delete databases.


That being said that would also explain why the phpmyadmin_rename doesn't work - just tested it locally, what it actually does is this:

We'll say I have OldDB and want to rename to NewDB. PHPMyAdmin creates NewDB, selects all the data in OldDB, creates new tables that match the OldDB tables in NewDB, puts the data into NewDB, then erases OldDB.

In short, it doesn't actually rename the database, so much as it creates a new one and copy+pastes the data over. Since cPanel is what's needed to make a new database, phpmyadmin throws an error right on the first part.



Juuust throwing that out there, cause it explains why phpmyadmin's not able to rename, add, or delete. Something to do with cPanel doing the counting means phpmyadmin can modify the heck out of the db's, but not make or erase them.

 

[rufussweetwater]

oh i see now, that would make sense. because that cykadmin_shoutbox DB was my third DB, and since I'm a free hosting user i am limited to three DBs. So when i tried to rename it it gave me the error saying that i had no privileges because i had maxed out my DB numbers.

:biggrin: :biggrin: Thanks for your help both of you... :biggrin: :biggrin: