Cannot delete a database

[epoclaen]

Hi,
I have 3 databases listed under "MySQL@databases". When trying to delete the epoclaendatabase it says that the database has been deleted but after hitting the "Go Back" link it still shows up in "MySQL@databases". It also shows up in phpMyAdmin. Interestingly, it does not include the pre-cursor of "{account name}_" like epoclaen_phpnews and epoclaen_serendipity do.

Could an admin please delete this for me or is there a way to do this myself?

Thanks,
Jeff

 

[Corey]

Looks to be a bug with cPanel. It will not be fixed until the next release.

http://forums.cpanel.net/showthread.php?t=76807

I'll plan to update cPanel this Tuesday.

 

[epoclaen]

Thanks Corey, I'll just wait until Wednesday to see if the cPanel release has the bug fixed then and re-open this thread if I still have issues.

 

[Corey]

Sounds good.

 

[epoclaen]

I waited until the end of the day but no luck - I tried to delete the epoclaen database through MySQL Databases and it's still there.

 

[Corey]

I had to push the cPanel update to tomorrow night.

I'll administratively remove the database for you now though.

-Corey

 

[epoclaen]

I hope this didn't break anything but I manually deleted the database myself using PHP and MySQL. It appears to have worked just fine seeing as Fantastico recognizes that I have just the 2 databases now. For those with the same issue, here is the code (Corey, scream if this info is bad so I can remove it).

<?php
$dbhost = 'localhost';
$dbuser = 'username';
$dbpass = 'password';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die                      ('Error connecting to mysql');

$dbname = 'databasename';
mysql_select_db($dbname);
$query  = 'DROP DATABASE databasename';
$result = mysql_query($query);
mysql_close($conn);
?>

 

[Corey]

That's fine.