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

Home / Forums Index / WebmasterWorld / Webmaster General
Forum Library, Charter, Moderators: phranque

Webmaster General Forum

    
deleting databases and tables in phpMyAdmin
sorry if this is the wrong forum...
superbird

10+ Year Member



 
Msg#: 9188 posted 9:13 pm on Jul 7, 2005 (gmt 0)

I must be missing something, how do I do it? I have loads of stuff I don't use anymore

 

The Contractor

WebmasterWorld Senior Member 10+ Year Member



 
Msg#: 9188 posted 9:14 pm on Jul 7, 2005 (gmt 0)

drop the tables

superbird

10+ Year Member



 
Msg#: 9188 posted 9:26 pm on Jul 7, 2005 (gmt 0)

Thanks!
Do I have to do that where I want to get rid of the whole db as well as just some of the tables?

coopster

WebmasterWorld Administrator coopster us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 9188 posted 9:29 pm on Jul 7, 2005 (gmt 0)

DROP TABLE removes one or more tables.
DROP DATABASE drops all tables in the database and deletes the database. But, as the MySQL manual warns "Be very careful with this statement!" because you are going to lose everything in the database if you do!

You probably just want to DROP TABLE by the looks of your request.

physics

WebmasterWorld Senior Member 10+ Year Member



 
Msg#: 9188 posted 9:33 pm on Jul 7, 2005 (gmt 0)

In phpMyAdmin it's pretty easy to do things like this. I.e. to drop a table select the database in the drop-down menu on the left. Then click on the table name you want to drop on the left. Then on the top right one of the tabs is "Drop".

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / WebmasterWorld / Webmaster General
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