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]

Reply via email to