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]

Reply via email to