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

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

Databases Forum

    
Deleting a "test databse"
tiki16

5+ Year Member



 
Msg#: 3208117 posted 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

WebmasterWorld Senior Member 10+ Year Member



 
Msg#: 3208117 posted 4:30 pm on Jan 4, 2007 (gmt 0)

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

tiki16

5+ Year Member



 
Msg#: 3208117 posted 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

WebmasterWorld Senior Member 10+ Year Member



 
Msg#: 3208117 posted 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

5+ Year Member



 
Msg#: 3208117 posted 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

WebmasterWorld Senior Member eelixduppy us a WebmasterWorld Top Contributor of All Time 5+ Year Member



 
Msg#: 3208117 posted 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

5+ Year Member



 
Msg#: 3208117 posted 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

5+ Year Member



 
Msg#: 3208117 posted 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

WebmasterWorld Senior Member eelixduppy us a WebmasterWorld Top Contributor of All Time 5+ Year Member



 
Msg#: 3208117 posted 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.
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