homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Visit PubCon.com
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

Deleting a "test databse"

 4:26 pm on Jan 4, 2007 (gmt 0)

Hello all, I am a mysql newb. I am familiarising myself with phpmyadmin and created a test database on the server. I'd like to delete it but don't know how. I have checked around and have found how to do this.



 4:30 pm on Jan 4, 2007 (gmt 0)

the option to delete is called , DROP just see the tab over there


 6:05 pm on Jan 4, 2007 (gmt 0)

This merely deletes a table within a DB. I want to remove the Db so that it is no longer within the Db directory in phpmyadmin.


 6:30 pm on Jan 4, 2007 (gmt 0)

DROP TABLE 'name_here' will delete just the table...but...DROP SCHEMA 'name_here' will delete the tables and the schema.



 8:40 pm on Jan 4, 2007 (gmt 0)

I don't have a DROP SCHEMA option. only DROP table?
Is this because of phpmyadmin or security settings on the server?
I was able to do it with phpmyadmin residing locally on my puter?


 9:57 pm on Jan 4, 2007 (gmt 0)

If you are using phpmyadmin click on your domain linked at the top:
Server: example.com. Then on the list that comes up you will see Databases; click it. This will give you a list of all of the databases. Now select the check box near the database you want to remove and click the Drop button at the bottom of the screen.

This should do it for you. ;)


 4:37 pm on Jan 5, 2007 (gmt 0)

HI eelix,
when i click databases i get a list of the db's but there is no checkbox for me to select a db. I can only click the db name which loads the db?
phpmyadmin running locally on my pc allows this.


 5:12 pm on Jan 5, 2007 (gmt 0)

Also, I am using a cms called joomla which creates the database through a directory module to allow users to input business details into the databse. Could this be the reason that the db's i create can't be deleted?


 4:25 am on Jan 6, 2007 (gmt 0)

>>>Could this be the reason that the db's i create can't be deleted?

I'm not quite sure what is wrong then. There are three ways that I see it:
1) You have another version of phpmyadmin that I am not familiar with
2) You are logged in with an account that does not have the permissions to drop databases
3) You are not looking in the correct place ;)

Other than this I do not think I can be of more help. Maybe someone else knows what you are experiencing?

Anyway, best of luck!

Global Options:
 top home search open messages active posts  

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved