cPanel bug - username database added
For those folks wondering about the empty database in their cPanel (should they have it), the following explanation was provided by cPanel:
Build 21703 provided two fixes that create the behavior being described in this thread. Earlier I posted these, but here is a more thorough description.
Prior to build 21565:
1. And any all accounts restored from backup (and transfers) would have an empty database created. This database name was the same name as the user (e.g. user name is cpken, database name thus is cpken). This database creation was not intentional, it was a bug.
2. Databases that were the same name as the user (user name is cpken, database name is cpken) were not accounted for in the tally of databases used by an account, nor were they displayed in the interface.Builds 21565 and newer:
1. No longer creation the empty database upon account restoration/transfer
2. Display and account for all databases associated with a user name.With that said, users currently cannot delete a database whose name matches the user name (db name of cpken as opposed to cpken_name). This matter should be attended to in the next build(s).
In other words, it’s a woops, and you are unable to delete the database yourselves. Just submit a support ticket, and we’ll nuke the little sucker for you.
What about the empty database called _default ?
What is its purpose?
Can it be deleted?
I probably knew the answer to this once but I can’t remember as present.
[Reply]
Kevin Taylor on April 9th, 2008 at 4:26 am
I think that the _default is a leftover from another platform we were on and can be safely deleted HOWEVER… I would look in phpmyadmin just to be sure. If you’re not sure how to look at a database, email us at support and we’ll look on your site and see if you have defined that database for anything. If you haven’t, its likely safe to nuke.
[Reply]
DrakNet on April 9th, 2008 at 7:18 pm
Ok, cPanel came up with an argument to nuke them all, so all the dangling databases should be nuked and you should have your resources back.
[Reply]
DrakNet on April 9th, 2008 at 9:36 pm
Well, the username_default database was empty, so I deleted it.
I now have one for Coppermine and one for SMF, but my Cpanel front page still says I have 3 databases.
[Reply]
Kevin Taylor on April 10th, 2008 at 3:43 pm
With regard to my last comment - refreshing the Cpanel front page 15 minutes later now shows the count reduced.
[Reply]
Kevin Taylor on April 10th, 2008 at 4:00 pm
Things within your cPanel can be cached, so sometimes it takes a few minutes for it to update.
[Reply]
DrakNet on April 10th, 2008 at 5:45 pm