Awesome!!!! I did create some text files in that database directory few days ago. And you are right, that does the trick.
After I moved those text files, the *drop* works!!! :-) thanks Heikki. BTW, how can I rename a database? feng ----- Original Message ----- From: "Heikki Tuuri" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 01, 2003 5:09 PM Subject: Re: can NOT drop the database > 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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]