Hi, > > By default, InnoDB tables aren't stored in the database folder, but rather > > in it's own table space files. > > > > In fact when I try to drop the database, the server "recognizes" > innodb tables. For example, T1 and T2 are INNODB tables in database > DB1. Then when I try to drop DB1, it issues error "Unknown tables (T1, > T2)".
Why do you think it "recognizes" them? I have a database with only 1 table, but if I type this: drop table foo (foo doesn't exist) I get: #42S02Unknown table 'foo' Same error :-) > If InnoDb own its table space... where is it reside ? I believe directly under the \data folder. Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle & MS SQL Server Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]