On Aug 15, 2005, at 5:07 AM, Logan, David (SST - Adelaide) wrote:
Hi Gary,
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.
David is right in that once you do this it won't show in the show
databases list any more, but if you use a data engine that stores
data in a shared table space (such as InnoDB to name one) doing this
deletes the database as far as MySQL is concerned, but the data is
still sitting in the shared spaces with no practical way of getting
it out and freeing your space.
The correct way will be to make sure you enclose the database name in
backticks as previously mentioned in this thread.
Best Regards, Bruce
Regards
David Logan
Database Administrator
HP Managed Services
148 Frome Street,
Adelaide 5000
Australia
+61 8 8408 4273 - Work
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax
-----Original Message-----
From: Gary Huntress [mailto:[EMAIL PROTECTED]
Sent: Monday, 15 August 2005 9:09 AM
To: mysql@lists.mysql.com
Subject: cannot drop database
I need to drop a database named ÃáãÃáà using the mysql client.
I'm
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?
Regards,
Gary H.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]