> > By default, InnoDB tables aren't stored in the database folder, but
> > 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,
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.
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Database development questions? Check the forum!