Re: can NOT drop the database

2003-10-06 Thread Heikki Tuuri
ttäjä: "Adam Hardy" <[EMAIL PROTECTED]> Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]> Lähetetty: Monday, October 06, 2003 1:14 PM Aihe: Re: can NOT drop the database > Thanks Heikki. > > In the output of innodb_table_monitor I can't actually see the

Re: can NOT drop the database

2003-10-06 Thread Heikki Tuuri
<[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, October 05, 2003 11:11 PM Subject: Re: can NOT drop the database > Just got back onto this again now. > > To quote the docs you pointed me at: > > >>>>>>>>>>>> > If MySQL

Re: can NOT drop the database

2003-10-05 Thread Adam Hardy
l.com/support/index.html - Alkuperäinen viesti - Lähettäjä: "Adam Hardy" <[EMAIL PROTECTED]> Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]> Kopio: <[EMAIL PROTECTED]> Lähetetty: Wednesday, October 01, 2003 3:24 PM Aihe: Re: can NOT drop the databas

Re: can NOT drop the database

2003-10-01 Thread Wang Feng
> As long as two databases are on the same disk you can also rename from one > database to another: > RENAME TABLE current_db.tbl_name TO other_db.tbl_name; Works!! :-) But the thing is: by doing this, although the tables have been *moved* from the old database to the new one, the old database

Re: can NOT drop the database

2003-10-01 Thread Heikki Tuuri
Feng, - Alkuperäinen viesti - Lähettäjä: "Wang Feng" <[EMAIL PROTECTED]> Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]> Lähetetty: Wednesday, October 01, 2003 11:26 AM Aihe: Re: can NOT drop the database > > > > BTW, how can I rename

Re: can NOT drop the database

2003-10-01 Thread Heikki Tuuri
ED]> Kopio: <[EMAIL PROTECTED]> Lähetetty: Wednesday, October 01, 2003 3:24 PM Aihe: Re: can NOT drop the database > Hi Heikki, > > a similar problem happened to me and I got the error: > > ERROR 1051: Unknown table '#sql-ffa_2,#sql-2b2_30' > > After reading your

Re: can NOT drop the database

2003-10-01 Thread Adam Hardy
- 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,

Re: can NOT drop the database

2003-10-01 Thread Heikki Tuuri
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

Re: can NOT drop the database

2003-10-01 Thread Wang Feng
t; <[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

Re: can NOT drop the database

2003-10-01 Thread Heikki Tuuri
> > > 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 ? > > &

Re: can NOT drop the database

2003-09-30 Thread Wang Feng
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 comman