List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:January 31 2008 2:30pm
Subject:Re: Data folder copying problem
View as plain text  
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

Thread
Data folder copying problemFeris Thia31 Jan
  • Re: Data folder copying problemMartijn Tonies31 Jan
    • Re: Data folder copying problemFeris Thia31 Jan
  • Re: Data folder copying problemMartijn Tonies31 Jan
    • Re: Data folder copying problemFeris Thia31 Jan
Re: Data folder copying problemFeris Thia31 Jan