homepage Welcome to WebmasterWorld Guest from 54.204.215.209
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
Subscribe to WebmasterWorld
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderators: physics

Databases Forum

    
Deleting a "test databse"
tiki16




msg:3208119
 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.
thanx

 

benevolent001




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

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

tiki16




msg:3208308
 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.
regards

justageek




msg:3208351
 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.

JAG

tiki16




msg:3208504
 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?
regards

eelixduppy




msg:3208606
 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. ;)

tiki16




msg:3209430
 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.
?
thanx

tiki16




msg:3209483
 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?
regards

eelixduppy




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

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

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.
Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About
© Webmaster World 1996-2014 all rights reserved