If you are running unix (or variants thereof), you can go to the data directory and remove
it at the operating system level if the mysql client can't do it. Not sure about windows
though but I would think the same thing would apply.
If you do that and then do a show databases, it should be gone.
HP Managed Services
148 Frome Street,
+61 8 8408 4273 - Work
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax
From: Gary Huntress [mailto:ghuntress@stripped]
Sent: Monday, 15 August 2005 9:09 AM
Subject: cannot drop database
I need to drop a database named
ÃÃ¡Ã£ÃÃ¡Ã using the mysql
getting "you have an error in your sql syntax" for the command
DROP database ÃÃ¡Ã£ÃÃ¡Ã;
I'm sure this is a character set issue. How can I drop this database?
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=1