Jump to content

Delete Database Disabled by Webhost


Recommended Posts

If you have to actually *delete* it, this won't work.

But if all you want to do is effectively kill it and remove the data from within, for security reasons:

Go into phpMyAdmin, select the database, select all the tables and use the DROP command.

Link to comment
Share on other sites

I don't think you can delete the database within phpMyAdmin, but I'm not 100% sure. On my dedi, even the root user doesn't have the option. I might have missed a config setting when I set it all up, but I don't think so.

Either way, perhaps the simplest thing would be to open a support ticket with your host, and have *them* delete the database.

Link to comment
Share on other sites

I can on my shared hosting, at least I think I did a long time ago (around 2006)

Select the database (from the left side panel) so you are viewing the tables etc, then along the very top choose "Drop"

Please make 100% sure you are looking at the right database first :o


Alternative: Cpanel > MySQLDatabases > Sometimes there is an option here to delete it (along with the assigned database users too)

:)

Link to comment
Share on other sites

AndyF,

I know it's splitting hairs, but DROP != DELETE. He already dropped all tables, resulting in an empty database.

But inside phpMYAdmin there's no option that I can find to actually *delete* the database, which is what he originally wanted to do.

In my case, I have to use the cPanel -> MySQL Databases menu to delete a database, even as the root user. (Caveat: Like I said, I may have missed a setting in phpMyAdmin, but I don't think so.)

Link to comment
Share on other sites

If permissions allow, you can still "delete" a database by dropping it (DROP DATABASE dbname) from within phpMyAdmin, like you can the tables. As Andy said, if you click on the database in the left hand column you should see a Drop tab on the top right of the table listing (now empty since you've dropped all the tables). This should drop (delete) the entire database assuming you have permissions to do so.

Link to comment
Share on other sites

Well, it's not exactly "2 step". You can drop a database with tables in it.

This will simply drop a table within a database


While this will drop an entire database, including any tables within it

DROP TABLE table_name;
DROP DATABASE database_name;
Link to comment
Share on other sites

  • 2 weeks later...

[quote name='RainbowViper' date='22 June 2009 - 09:02 AM' timestamp='1245690125' post='1812511']
AndyF,

I know it's splitting hairs, but DROP != DELETE. He already dropped all tables, resulting in an empty database.

But inside phpMYAdmin there's no option that I can find to actually *delete* the database, which is what he originally wanted to do.

In my case, I have to use the cPanel -> MySQL Databases menu to delete a database, even as the root user. (Caveat: Like I said, I may have missed a setting in phpMyAdmin, but I don't think so.)


Correct - I have dropped the tables, resulting in an empty database and yes I am aware of this other option of deleting the databases through cpanel but you may like to call it starnage or whatever but i was able to successfully delete one database with that option but thereafter couldn't. Although cpanel claims that database has been deleted but it isn't deleted in actual.


[quote name='Brandon D' date='22 June 2009 - 09:11 AM' timestamp='1245690687' post='1812521']
If permissions allow, you can still "delete" a database by dropping it (DROP DATABASE dbname) from within phpMyAdmin, like you can the tables. As Andy said, if you click on the database in the left hand column you should see a Drop tab on the top right of the table listing (now empty since you've dropped all the tables). This should drop (delete) the entire database assuming you have permissions to do so.



[quote name='Brandon D' date='22 June 2009 - 09:14 AM' timestamp='1245690857' post='1812523']
Well, it's not exactly "2 step". You can drop a database with tables in it.

This will simply drop a table within a database


While this will drop an entire database, including any tables within it



I tried that too before coming up here but again that doesn't works for me because of permission issues.

DROP TABLE table_name;
DROP DATABASE database_name;
Link to comment
Share on other sites

Given what you've said, you definitely need to get your host involved. Especially if the database isn't showing up in cPanel, but is still listed in phpMyAdmin.

Did you contact them before?

Are they giving you a ration of grief, or just not responding?

Link to comment
Share on other sites

[quote name='RainbowViper' date='01 July 2009 - 12:15 PM' timestamp='1246479332' post='1818506']
Given what you've said, you definitely need to get your host involved. Especially if the database isn't showing up in cPanel, but is still listed in phpMyAdmin.

Did you contact them before?

Are they giving you a ration of grief, or just not responding?


I don't think I have ever said that databases shows up in phpmyadmin and not in cpanel.... All I said was that even though it says database deleted successfully in the cpanel when attempted but in actual it isn't deleted.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...