phantom666 Posted June 4, 2018 Share Posted June 4, 2018 Username: demon666Domain: phantomtest.heliohost.orgServer: johnny Hi, I've recreated my account on johnny, and now I am in the process of setting up my databases. However, I seem unable to create a database (demon666_contactdb) because it's says it already exists, but I can't seem to see this database anywhere. If this database does indeed exist, I would like it removed. Please can anyone assist? Thanks in advance. D Quote Link to comment Share on other sites More sharing options...
rajdis Posted June 4, 2018 Share Posted June 4, 2018 You can check it by going into phpMyAdmin Quote Link to comment Share on other sites More sharing options...
phantom666 Posted June 4, 2018 Author Share Posted June 4, 2018 Hi, When I go into phpMyAdmin, there only appears to be one database I created present (demon666_world), which would imply that the database demon666_contactdb does not exist. When I go into MySQL Databases from cPanel, again, I can only see the database demon666_world present, but when I attempt to create a new database with the name of demon666_contactdb, I get an error message informing me that this database already exists, even though I cannot see it anywhere, so I am not sure why I am presented with this error. Cheers, D Quote Link to comment Share on other sites More sharing options...
DmC Posted June 4, 2018 Share Posted June 4, 2018 What happens if you run the sql command from phpmyadmin: DROP DATABASE demon666_contactdb; Quote Link to comment Share on other sites More sharing options...
phantom666 Posted June 4, 2018 Author Share Posted June 4, 2018 I get the following error message in phpmyadmin when attempting to run the above command: ErrorSQL query: DROP DATABASE demon666_contactdb MySQL said: "DROP DATABASE" statements are disabled. Quote Link to comment Share on other sites More sharing options...
phantom666 Posted June 11, 2018 Author Share Posted June 11, 2018 Apologies for sounding impatient, but can someone offer any assistance to the issue I have described above? In short, I am unable to create a new database because apparently it already exists, however, I can't seem to see this database anywhere, and I am unable to manually run any commands to force a deletion. Any assistance will be greatly appreciated. Thanks in advance. Cheers, D Quote Link to comment Share on other sites More sharing options...
wolstech Posted June 11, 2018 Share Posted June 11, 2018 Best bet is to just use a different database name. The one you're having issues with won't drop for me either, so it's probably half-created and corrupt. Quote Link to comment Share on other sites More sharing options...
phantom666 Posted June 12, 2018 Author Share Posted June 12, 2018 Looks like I'm going to have to create the database using a different name, which means updating my any scripts with the new name accordingly Anyway, thanks to everyone for their assistance. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.