Feng, do you have some non-MySQL file in that database directory under the datadir of MySQL?
Naturally, MySQL will not drop the directory if it contains something more than just MySQL tables. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for MySQL Order MySQL technical support from https://order.mysql.com/ ----- Original Message ----- From: ""Wang Feng"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Wednesday, October 01, 2003 8:37 AM Subject: Re: can NOT drop the database > Not at all!! > > after I typed the 'drop database my_account_database', I got the following > message: > > > Query OK, 0 rows affected (0.00sec). > > and I do the 'show databases', that one is still there. > > > cheers, > > feng > > > ----- Original Message ----- > From: <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, October 01, 2003 3:31 PM > Subject: Re: can NOT drop the database > > > > no permissions errors ? > > > > > Greetings, > > > > > > > > > I have a database called 'my_account_database' and I tried to drop it > > > by the command 'drop database my_account_database', it doesn't work. > > > The database is still there, can not be dropped although the tables > > > contained in the database have gone. > > > > > > I subsequently created another 2 databases and could drop them > > > successfully. > > > > > > Tried the 'drop database my_account_database' again before sending this > > > message, still doesn't work. > > > > > > > > > So, what could be the problem? Have you seen this situation before? > > > > > > > > > btw, I can't find out any command which can be used to simply rename a > > > database, please advise!! > > > > > > > > > cheers, > > > > > > feng > > > > > > > > > > > > -- > > > MySQL General Mailing List > > > For list archives: http://lists.mysql.com/mysql > > > To unsubscribe: > > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]