Adam, you can use the innodb_table_monitor
http://www.innodb.com/ibman.html#InnoDB_Monitor and the advice at http://www.innodb.com/ibman.html#InnoDB_troubleshooting_dict to resolve the problem. Best regards, Heikki Innobase Oy http://www.innodb.com InnoDB - transactions, row level locking, and foreign keys for MySQL InnoDB Hot Backup - a hot backup tool for MySQL Order MySQL support from http://www.mysql.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 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 post, I checked in the data directory and there are > two files there, both of file type data: > > #sql-2b2_30.frm > #sql-ffa_2.frm > > I certainly didn't put them there myself - I think they must have come > from mySQL automatically at some point. > > Are they real tables in the database? I can't see them when I use 'show > tables'. Is it a permissions problem? I have this on another database > that I was trying to restore from a dump. I had to rename the database > in the end. > > I am using InnoDB tables for some of my data. > > Regards > Adam > > On 10/01/2003 09:09 AM Heikki Tuuri wrote: > > 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] > > > > > > > > > > -- > Running mySQL 4.1.0 on Linux 2.4.20 RH9 > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]