Web Hosting Talk







View Full Version : delete mysql database??


linda7255
06-29-2004, 07:33 PM
Hi,

How do I delete mysql database in dos mode?

Thanks,
Linda

Loon
06-29-2004, 07:45 PM
DROP DATABASE dbname;

be careful =P

alpha
06-29-2004, 07:54 PM
Originally posted by Loon
DROP DATABASE dbname;

be careful =P

Before being carefully as Loon suggested, make sure you're logged into the mysql server.

In order to do that, you need to find \mysql\bin\mysql.exe and run that executable from the command-line.

linda7255
06-29-2004, 07:58 PM
I try this but it just doesn't work. I noticed what ever command I enter in, I will get this

->

Did I install the wrong version of mysql or something?

C:\MYSQL\BIN>drop database laborlaws
'DROP' is not recognized as an internal or external command,
operable program or batch file.

C:\MYSQL\BIN>mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 79 to server version: 4.0.20a-debug

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> drop database laborlaws
-> ****
->

alpha
06-29-2004, 08:00 PM
Linda, you're forgetting the semicolon in the end of your mysql command.

DROP database laborlaws;