LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 11-06-2003, 09:05 AM   #1
shelby
Member
 
Registered: Nov 2002
Location: Rio Rancho, NM
Distribution: RHEL, CentOS & Ubuntu
Posts: 90

Rep: Reputation: 15
How do I remove a database in mysql?


How do I remove a database in mysql? I looked through the documentation but did not see it. Thanks
 
Old 11-06-2003, 09:28 AM   #2
jim mcnamara
Member
 
Registered: May 2002
Posts: 964

Rep: Reputation: 35
Do you mean you want to drop a schema?

Or do you want to clobber all of the files and programs?
 
Old 11-06-2003, 10:06 AM   #3
shelby
Member
 
Registered: Nov 2002
Location: Rio Rancho, NM
Distribution: RHEL, CentOS & Ubuntu
Posts: 90

Original Poster
Rep: Reputation: 15
When I do a SHOW DATABASES; it list all of the databases I have. I want to remove one of those in that list. Thanks
 
Old 11-06-2003, 10:30 AM   #4
lazygrafx
LQ Newbie
 
Registered: Sep 2003
Posts: 6

Rep: Reputation: 0
just do a DROP DATABASE `database name';
 
Old 11-06-2003, 10:41 AM   #5
shelby
Member
 
Registered: Nov 2002
Location: Rio Rancho, NM
Distribution: RHEL, CentOS & Ubuntu
Posts: 90

Original Poster
Rep: Reputation: 15
Worked! Thanks
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Writing an app that uses a mysql database without installing mysql server? QtCoder Programming 4 08-09-2004 02:43 PM
Remove package from RPM database? breddy Linux - Newbie 1 07-21-2004 11:51 PM
MYSQL help - mysql database missing eloviyandhi Linux - Software 1 03-20-2004 09:20 PM
remove listings from udatedb database linuxnube Linux - General 2 02-01-2004 08:29 PM
remove a database service from autostart ncole Linux - General 1 01-20-2003 04:07 PM


All times are GMT -5. The time now is 02:04 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration