Wang, ----- Original Message ----- From: "Wang Feng" <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, October 01, 2003 10:30 AM Subject: Re: can NOT drop the database
> 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? if you only have MyISAM tables, you can shut down mysqld and rename the directory. But that does not work for InnoDB tables. For them, the only way is to use the command RENAME to raname each table individually. > feng 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: "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]