Re: cannot drop database

2005-08-16 Thread Bruce Dembecki
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

RE: cannot drop database

2005-08-15 Thread Logan, David (SST - Adelaide)
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 shoul

Re: cannot drop database

2005-08-15 Thread Martijn Tonies
> 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? What about using backticks around it: drop database

Re: cannot drop database

2005-08-15 Thread Terence
Try DROP database `ÃáãÃáÃ`; Gary Huntress wrote: 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