Welcome to WebmasterWorld Guest from 54.163.40.152

Forum Moderators: open

Message Too Old, No Replies

Deleting a "test databse"

     

tiki16

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

5+ Year Member



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

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

WebmasterWorld Senior Member 10+ Year Member



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

tiki16

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

5+ Year Member



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

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

WebmasterWorld Senior Member 10+ Year Member



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

JAG

tiki16

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

5+ Year Member



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

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

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



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

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

5+ Year Member



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:12 pm on Jan 5, 2007 (gmt 0)

5+ Year Member



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

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

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



>>>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!

 

Featured Threads

Hot Threads This Week

Hot Threads This Month