From: Martijn Tonies
Date: January 31 2008 2:30pm
Subject: Re: Data folder copying problem
List-Archive: http://lists.mysql.com/mysql/211163
Message-Id: <02b401c86415$d2b6b820$9902a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

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